How to Find SQL Server Jobs Starting at the Same Time?
Category: Performance
Why should you care about them?
Multiple SQL Server Agent jobs are configured to start at the same time, and this will not be performed as fast as if the jobs were not overlapping. Your SQL Server may be under heavy load for short periods of time.
How can we find SQL Server jobs that start at the same time?
You can use the following script to list all Agent SQL Server jobs that start at exactly the same time.
SELECT j.name As JobName,
j.description AS JobDescription,
a.start_execution_date AS JobStartExecutionDate
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobactivity a ON j.job_id = a.job_id
WHERE j.enabled = 1 AND a.start_execution_date IN
(SELECT start_execution_date
FROM msdb.dbo.sysjobactivity
GROUP BY start_execution_date HAVING COUNT(*) > 1)
