Here is a handy script for checking upcoming scheduled jobs for the Microsoft SQL Server Agent.

[fancy_pre_box]
SELECT job.[job_id] AS [JobID]
,job.[name] AS [JobName]
–Convert integer date yyyymmdd and integer time [h]hmmss
–into a readable date/time field
,CONVERT(VARCHAR(50),
CAST(STUFF(STUFF(CAST(jobsch.[next_run_date] AS VARCHAR(8))
,5
,0
,’-‘)
,8
,0
,’-‘) AS DATETIME)
+ CAST(STUFF(STUFF(CAST(RIGHT(‘000000′
+ CAST(jobsch.[next_run_time]
AS VARCHAR(6))
, 6) AS VARCHAR(8))
,3
,0
,’:’)
,6
,0
,’:’) AS DATETIME)
,100) AS [Next Run Time]
FROM [msdb].[dbo].[sysjobs] AS job
LEFT JOIN [msdb].[dbo].[sysjobschedules] AS jobsch
ON (job.[job_id] = jobsch.[job_id])
LEFT JOIN [msdb].[dbo].[sysschedules] AS syssch
ON (jobsch.[schedule_id] = syssch.[schedule_id])
WHERE job.[enabled] = 1
AND jobsch.[next_run_date] IS NOT NULL
AND jobsch.[next_run_date] > 0
ORDER BY jobsch.[next_run_date]
,jobsch.[next_run_time];
[/fancy_pre_box]