May 14, 2003 at 2:10 pm
We're doing some testing in which we have to set the time back. However, the scheduled jobs seem to not be starting because the 'next run date' is far in the future. How can you clear this as if you had just created the job?
May 14, 2003 at 2:14 pm
Just solved this. I generated a sql script of the jobs, deleted them and then ran the script to recreate the jobs.
May 14, 2003 at 3:45 pm
Simply right click on the job, click property, select schedule, click edit, then select the schedule you want, monthly, daily, or just once, whatever you want.
Robert
May 14, 2003 at 4:28 pm
'next run date' isn't something you can set in the scheduling. The jobs are already scheduled and created. Going back through and rescheduling them all (if this would even reset the 'next run date') would be impractical. The answer for me is the reply above. Deleting and recreating the jobs with a sql script is quick and resets the 'next run date' to the current day and time of schedule. This is only a problem because I'm rolling the date backwards while doing my testing and this puts my 'next run date' a week in advance so my jobs never run.
Edited by - cyblue on 05/14/2003 4:31:06 PM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply