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
asked Apr 04 '12 at 12:34 PM in Default
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 ♦♦
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.
If you want more info abut either, let me know.
answered Apr 04 '12 at 05:45 PM
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