SQL Agent Miscellaneous
msdb.dbo.sysjobhistory
run_date is an INT in the format 'yyyyMMdd'. To get a value to compare, e.g. TODAY, use SELECT FORMAT(GETDATE(), 'yyyyMMdd')
How SQL Server Determines the Next Run Date for SQL Agent Jobs
SQL Server calculates the next run date for SQL Agent jobs based on the job's schedule configuration stored in the msdb database. The key components involved in this process include the sysjobschedules , sysschedules , and sysjobactivity tables, along with background processes in the SQL Server Agent. Key Mechanism for Next Run Date Calculation The next run date and time are primarily stored in the sysjobschedules table. However, these values are not updated in real-time. Instead, they are refreshed periodically by a background thread in SQL Server Agent, known as the "Schedule Saver" thread , which typically runs every 20 minutes. This delay can cause discrepancies if you check the sysjobschedules table immediately after modifying a schedule. For real-time updates, the sysjobactivity table is more reliable. This table is updated immediately whenever a job sch...
Comments
Post a Comment