Viewing 5 posts - 1 through 5 (of 5 total)
Check out this link, it may help:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q110352
December 27, 2001 at 8:31 pm
Andy,
I read up on it some and tried to use a variable marked for output, but couldn't figure out the right code. I tried some example codes, but didn't have...
December 27, 2001 at 3:47 pm
Hi,
I found the problem. The sp_help_jobstep documentation says that last_run_duration is an int expressed as: "Duration (in seconds) of the step the last time it ran." In reality last_run_duration...
December 26, 2001 at 2:13 am
Thanks,
Sounds like a good idea. I'll try it in the coming days and let you know what I find out.
Happy Holidays!
April
December 24, 2001 at 11:30 am
It is a ton of work...the reason I was using the sp_help_jobstep is because I actually wanted to get the duration without calculating it (or storing it, since the msdb...
December 21, 2001 at 11:00 pm
Viewing 5 posts - 1 through 5 (of 5 total)