Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duration for a job
Message
From
05/04/2015 14:05:30
 
 
To
04/04/2015 20:54:08
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01617785
Message ID:
01617791
Views:
30
>>We created a table to hold job name, start time and finish time .
>
>Can you elaborate more on this? So far, on my end, the DBA has created a restore procedure which sits on the Jobs treeview section and I only execute it from there.


I retired last year, so I don't have the scripts in front of me. Most of our jobs called a stored procedure. The SP inserted a record into Duration table with job name and start time. On completion, the script updated the Duration record with the end time. For some jobs we stored record counts or other useful information. We also stored error codes if there was an issue during the job run.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform