job duration

Hello,

I am checking "view history" of some job but the view history does not have any histroy records,its empty.The job is disabled couple of months back and I could see the last job run date from Event Viewer,which shows the last job is run 8 month back.How can I identify the duration of this job which is run 8 month back?

I am using sql2008r2 enterprise edition

Thank you

asked Apr 04 '12 at 12:34 PM in Default

pits
830 ● 43 ● 76 ● 83

(comments are locked)

3 answers:

If the job completion was logged in the application log - then work out the difference between the logged date/time and the invocation date in the log message.

answered Apr 04 '12 at 12:46 PM

Kev Riley ♦♦
46.1k ● 38 ● 43 ● 69

(comments are locked)

Kev provides probably the best option.

But do you have a test server you could test it on? Also remember that in production any job duration measurements will only be rough ideas for future lengths of the jobs. Changing loads on the server, changing data sizes, increased fragmentation, and locking issues all make precise predictions for a job length very difficult.

answered Apr 04 '12 at 09:21 PM

TimothyAWiseman
14.3k ● 16 ● 20 ● 29

(comments are locked)

I hate to sound like a commercial, but job management has always been an issue for me. I have done a couple things that may not help you in this case, but something you may want to look into.

There is a great job management tool in the SQL Sentry product. Some of the things that I really get a lot of use out of is the job duration alerts. Things like if this job runs 200% longer than average send me a note.
The other thing that I do is create a utility database, here I can keep a lot of my won history of jobs and a number of other useful things.

If you want more info abut either, let me know.

Chris Shaw

answered Apr 04 '12 at 05:45 PM