Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Duration for a job
Message
De
06/04/2015 08:03:13
 
 
À
05/04/2015 14:05:30
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:
01617797
Vues:
31
>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.

Thanks
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform