Sample Header Ad - 728x90

Script to see running jobs in SQL Server with Job Start Time

21 votes
7 answers
191539 views
how to write script to see running jobs in SQL Server with Job Start Time? SELECT sj.name, sja.run_requested_date, CONVERT(VARCHAR(12), sja.stop_execution_date-sja.start_execution_date, 114) Duration FROM msdb.dbo.sysjobactivity sja INNER JOIN msdb.dbo.sysjobs sj ON sja.job_id = sj.job_id WHERE sja.run_requested_date IS NOT NULL ORDER BY sja.run_requested_date desc;
Asked by zerbug (329 rep)
Feb 13, 2014, 11:33 AM
Last activity: Nov 23, 2023, 10:26 AM