Want to know jobs which are scheduled for today at what time?

Question

Hi All,

Want to know what are the SQL Agent Jobs scheduled for today at what time they are going to run ?

Env : SQL Server 2017 CU23

Regards,

Sam

Answer 1

SELECT 
    j.name AS 'Job Name',
    js.step_name AS 'Step Name',
    js.command AS 'Step Command',
    j.enabled AS 'Is Enabled',
    js.subsystem AS 'SubSystem',
    js.database_name AS 'Database Name',
    j.date_created AS 'Date Created',
    j.date_modified AS 'Date Modified',
    CONVERT(DATETIME, CONVERT(VARCHAR(8), s.next_run_date, 112) + ' ' + STUFF(STUFF(RIGHT('000000' + CONVERT(VARCHAR(6), s.next_run_time), 6), 5, 0, ':'), 3, 0, ':'), 120) AS 'Next Run Time'
FROM 
    msdb.dbo.sysjobs AS j
INNER JOIN 
    msdb.dbo.sysjobsteps AS js 
ON 
    j.job_id = js.job_id
INNER JOIN 
    msdb.dbo.sysjobschedules AS jsched 
ON 
    j.job_id = jsched.job_id
INNER JOIN 
    msdb.dbo.sysschedules AS s 
ON 
    jsched.schedule_id = s.schedule_id
WHERE 
    j.enabled = 1 
    AND CONVERT(DATE, GETDATE()) = CONVERT(DATE, CONVERT(DATETIME, CONVERT(VARCHAR(8), s.next_run_date, 112), 112))
ORDER BY 
    'Next Run Time'