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
Last activity: Nov 23, 2023, 10:26 AM