General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2012
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only