SQL Server job suddenly does not work

The statement to be executed was not found. Later, the function was completed.

It was originally run once every minute, but it was not run for a long time. It was normal to run it manually. Why did it suddenly stop working? In addition, it is found that none of them work normally. I checked and found that the record was stopped at the "month", and the system now uses the month number. It turns out that this machine has been changed to the running time to the month number, and today it is changed back to the normal time.

: Since the next run time calculated previously is in the month number, and the current system is changed to the normal time after the month number, it will not run. Run the following code to check the next running time:

 

Schedule_idname jjob_idnext_run_time 66 next_run_time

Next_run_date

Sysjobschedules j

Sysjobs s sjob_id jjob_id

Name

@ Job_name

It is a time point of the month number.

: Export the script, delete the old one, and recreate it. Then it will work normally.

Next running time (I can see it on the Internet, but I have not tried it ).