List all Jobs set to Start Automatically when SQL Server Agent starts

SQL Server Agent jobs can be set to start automatically when SQL Server Agent starts.
To find all jobs set to run automatically when SQL Server Agent starts, use this query:


SELECT j.name AS 'Job Name'
FROM msdb.dbo.sysjobs j
JOIN msdb.dbo.sysjobschedules js ON js.job_id = j.job_id
JOIN msdb.dbo.sysschedules s ON s.schedule_id = js.schedule_id
WHERE s.freq_type = 64;

list_jobs_automatic_start

To see how to Schedule a Job to Start Automatically when SQL Server Agent starts, read related Article:
Schedule a Job to Start Automatically when SQL Server Agent starts

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">