|
|
Posted by Erland Sommarskog on 05/29/05 01:55
Mike (mjorlando@campsystems.com) writes:
> I've been trying to manipulate this job schedule in various ways, even
> deleting and recreating a new schedule for this job through the GUI in
> Enterprise Manager and still encounter this problem. Now when I set up
> this job with the (already past) start date of 5/23/2005 I would expect
> it to indicate that the next run date would be 6/20/2005 10PM, 28 days
> after 5/23/2005 10PM. The run duration of this job is between 7 and 8
> hours depending on processor load. But still it always says the next run
> date is the day that I set up the schedule.
An MVP colleague says that this is to be expected, when your date is
in the past, although I'm not really sure that I agree. When I test
to set up a job with a 28-day schedule, and with start date of
2005-05-23, I get a next run date of 2005-06-26, that is 28 days from
today. And the job does not run today.
It might be that it is not possible to use the start date, to specify
when the job should run the first time.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|