Home Dashboard Directory Help
Search

Change system date forward and then back cause stop job schedule to work by PaoloLec


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 804354
Opened: 10/2/2013 12:00:00 PM
Access Restriction: Public
1
Workaround(s)
view
1
User(s) can reproduce this bug

Description

If I change system date forward and then back, the job schedulated in sql server stop to work untill the date in the future is reached.
Details
Sign in to post a comment.
Posted by Microsoft on 10/17/2013 at 1:56 PM
Recreate jobs that have already run to ensure a sooner date is enforced.
Posted by Microsoft on 10/17/2013 at 1:55 PM
Hello Paolo. Triggering is set based on previous date of action of a job. You can work around this by recreating the job.
Sign in to post a workaround.
Posted by Microsoft on 10/17/2013 at 1:56 PM
Recreate jobs that have already run to ensure a sooner date is enforced.