question

Naren avatar image
Naren asked

How to know job when statred when completed and how much time it is running?

Maintainance plane Job was failed for one database... Need to check how much time the job is running? Actually that is in restricted growth and we increased the maxsize to that file but Need to know why that job failed and what are the steps we have what happend to that database?
sql-server-2005dba
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
So far you have asked 9 questions on this forum and have had 13 answers but have not marked any of them as having helped you. This wont encourage people to keep offering solutions to questions you pose. Would you be able to find some time to review the answers that you have had on other questions and mark appropriate one as helpful by clicking the tick beside them please? It isnt much to ask for all the assistance that is offered across this site. Thanks
3 Likes 3 ·
Usman Butt avatar image Usman Butt commented ·
@Naren, You must consider Mr. Fatherjack's suggestion. Hope you do that. After the anticipation, can you please clarify this statement in your question "we increased the maxsize to that file but". Your question is quite ambiguous and you should add more details. As far as job running time is concerned, it is very easy, you can find it out in msdb.dbo.sysjobhistory table. I am not giving it as an answer, because I think your question is something else which you were not able to portray.
0 Likes 0 ·
jhunu avatar image
jhunu answered
You can check the status of the failed job in View History option from the job's list . Same way in Maintenence Plan you can heck the view history option .
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
There are two possible places for errors, the SQL Server error log may have information about the failure. This is found under the Server Objects folder in Object Explorer. You also may see errors in the SQL Agent error log. This is found under the SQL Agent folder in the Object Explorer. Also, you can modify your jobs to provide an output file. This will contain a lot more detail if things go wrong to help you understand what happened. This is available on the Advanced paged of each Job Step.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.