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)
SQL Server Consulting
Need expert support for SQL Server?
Our senior database team supports SQL Server performance tuning, health checks, migrations, Remote DBA services and urgent operational issues.
Related Reading
SQL Server Managed DBA Services
Let Us Handle Your Day-to-Day SQL Server Operations
Aryasoft’s Remote DBA team manages maintenance plans, job/agent administration and ongoing server operations proactively.
