MS SQL Server - Scheduled job with @active_start_time AFTER @active_end

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Scheduled job with @active_start_time AFTER @active_end_time

jayneandkumar@gmail.com

2006-12-04, 7:12 pm

What happens if we have a scheduled job with the @active_start_time is
BEFORE @active_end_Time

As far as I can see from the online docuementation the only requirement
is that they be not equal.

Can anyone shed light on this ?

cheers,
Senthil

jayneandkumar@gmail.com

2006-12-04, 7:12 pm

Sorry, as the subject says (if the active_start_time is AFTER
@active_end_time)
and not before (which is the normal case) as I say below

jayneandkumar@gmail.com wrote:
> What happens if we have a scheduled job with the @active_start_time is
> BEFORE @active_end_Time
>
> As far as I can see from the online docuementation the only requirement
> is that they be not equal.
>
> Can anyone shed light on this ?
>
> cheers,
> Senthil

Sponsored Links