Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Duration for a job
Message
De
05/04/2015 14:05:30
 
 
À
04/04/2015 20:54:08
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01617785
Message ID:
01617791
Vues:
29
>>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
Fil
Voir

Click here to load this message in the networking platform