Sqlserver: The scheduling time of the agent job is inaccurate. The job stops.

Symptom:Proxy jobs often fail to be scheduled and executed due to OS time adjustment (post-adjustment and pre-adjustment!

Root cause:The execution of SQL Server Job Scheduling plan must comply with the following principles:

• Time cannot be adjusted later, for example, getdate ()-N. The adjusted time is earlier than the scheduled "next run time", and the job will not run.
• In the past, you cannot call a "active frequency Cycle (daily, weekly, or monthly)", or call a number of "active frequency cycles" (for example, the active frequency is daily, the frequency of occurrence is minute or hour.

Solution:

• Re-create the Job Scheduling plan
• Disable Job Scheduling and then enable this scheduling.

Related information

MSDB. DBO. sysjobschedules schedule table

Column name	Data Type	Description	Description
Schedule_id	Int	Scheduling ID.
Job_id	Uniqueidentifier	Job ID.
Name	Sysname	The name of the scheduling.
Enabled	Int	Scheduling activation status.
Freq_type	Int	Frequency of scheduling: 1 = once 4 = daily 8 = weekly 16 = monthly 32 = monthly relative information 64 = on SQL Server ProxyProgramRun at startup
freq_interval	int	indicates the value of the scheduled run date. If freq_type is 4 (daily), the value is every freq_interval days. If freq_type is 8 (per week ), the value indicates the bitmask of the weekly scheduled run date. freq_interval : 1 = Sunday 2 = Monday 4 = Tuesday 8 = Wednesday 16 = Thursday 32 = Friday 64 = saturday If freq_type is 16 (monthly), the value is freq_interval day of the month. If freq_type is 32 (relative monthly information ), freq_interval can be one of the following values: 1 = Sunday 2 = Monday 3 = Tuesday 4 = Wednesday 5 = Thursday 6 = Friday 7 = saturday 8 = day 9 = business day 10 = weekend
Freq_subday_type	Int	Freq_subday_intervalUnit: 1 = at the specified time 2 = seconds 4 = minutes 8 = hour
Freq_subday_interval	Int	Occurs between the execution of each scheduled jobFreq_subday_typeNumber of cycles.
Freq_relative _ Interval	Int	WhenFreq_typeIs 32 (relative monthly information), the monthly scheduled jobFreq_intervalOccurrence: 1 = first 2 = Second 4 = Third 8 = fourth 16 = last
Freq_recurrence _ Factor	Int	The number of weeks or months between scheduled jobs.
Active_start_date	Int	The date when the job starts.
Active_end_date	Int	The date when the job is stopped.
Active_start_time	Int	The time when the job starts.
Active_end_time	Int	The time when the job is stopped.
Next_run_date	Int	The date of the next job execution.
Next_run_time	Int	The time when the next job is executed.
Date_created	Datetime	The creation date of the scheduled job item.