Job ran for -95444:-89:-43 hours ??

I have a nightly job that runs at 2.00 AM....On saturday night first it ran
for -95444:-89:-43 and again ran at 2.00 AM

I know this occured beacuse we went back one hr on saturday night at 2.00
AM....My question is why the job should run again resulting in a failed
status? SQL Server should not have run this the second time.  I hope in SQL
2005 this does not happen.

Thanks,
Ranga

Hi

This would depend on when/how the next run date is calculated. This may be
how the scheduler is designed to work. If you moved the job off the hour you
should not see this occurring.

John

"Ranga" wrote:

> I have a nightly job that runs at 2.00 AM....On saturday night first it ra
n
> for -95444:-89:-43 and again ran at 2.00 AM
>
> I know this occured beacuse we went back one hr on saturday night at 2.00
> AM....My question is why the job should run again resulting in a failed
> status? SQL Server should not have run this the second time.  I hope in SQ
L
> 2005 this does not happen.
>
> Thanks,
> Ranga