Return
-
Title
Monthly jobs shown as Expired -
Description
Monthly jobs shown as Expired
-
Resolution
To fix issue with jobs displayed as Expired:
We need to set RangeStartDate a little bit ahead of current time, restart vRanger Pro service and it will run the jobs at thier next defined time after the value you set in RangeStartDate.
So for example, current date/time is 03/08/2011 11:58 AM.
You set RangeStartDate to "3/9/20110 12:00:00 AM".
Restart vRanger Service.
Job will be displayed in Ranger gui 'Next run' as expected.
Run following command in cmd on Ranger box and restart service:
sqlcmd -S \vRangerPro -d vRangerPro -Q "UPDATE Recurrence SET Recurrence.RangeStartDate='3/9/2011 12:00:00 AM'"