Thank this author by sharing:
SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some...
Adding Time Duration in SQL
Last executed query total duration
Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do...
The following script returns the run_duration as for example:
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.