Information générale
Forum:
Microsoft SQL Server
Versions des environnements
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement