Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2012
>Is there a way to obtain the duration when a job has completed? Script allows that in the status bar. But, jobs does not have the same functionality. I have a restore job and I need to collect the exact time this has taken. I need to evaluate the time it would take for a deployment. That varies from 55 to 75 minutes. If I could obtain the exact timeframe, that would be great.
We created a table to hold job name, start time and finish time .
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