|
|
|
Author |
Message |
BitMagic
|
Posted: Mon Apr 19 16:56:34 CDT 2004 |
Top |
SQL Server Developer >> job execution order
I have two jobs. One has schedule which fires when Agent stars. Another has
schedule which fires once per hour.
Is it guaranteed that first job will be executed before second job when SQL
server starts?
SQL Server294
|
|
|
|
|
Igor
|
Posted: Mon Apr 19 16:56:34 CDT 2004 |
Top |
SQL Server Developer >> job execution order
> I have two jobs. One has schedule which fires when Agent stars. Another
> has
> schedule which fires once per hour.
> Is it guaranteed that first job will be executed before second job when
> SQL
> server starts?
>
Is my question so hard to answer? Or is it hard to understand it?
|
|
|
|
|
Igor
|
Posted: Mon Apr 19 16:56:40 CDT 2004 |
Top |
SQL Server Developer >> job execution order
> I have two jobs. One has schedule which fires when Agent stars. Another
> has
> schedule which fires once per hour.
> Is it guaranteed that first job will be executed before second job when
> SQL
> server starts?
>
Is my question so hard to answer? Or is it hard to understand it?
|
|
|
|
|
Cherdian
|
Posted: Mon Apr 19 23:45:52 CDT 2004 |
Top |
SQL Server Developer >> job execution order
I'm not sure I understand well the situation. If you can be more
specific, that will help! however, with a lot of assumption on my side,
I think there's no guarantee that the first job will be executed before
the second. It depends on the thread scheduling.
> On Fri, 16 Apr 2004 16:40:15 +0300, Igor Solodovnikov
>
>> I have two jobs. One has schedule which fires when Agent stars.
>> Another has
>> schedule which fires once per hour.
>> Is it guaranteed that first job will be executed before second job
>> when SQL
>> server starts?
>>
>
> Is my question so hard to answer? Or is it hard to understand it?
|
|
|
|
|
Igor
|
Posted: Tue Apr 20 06:48:07 CDT 2004 |
Top |
SQL Server Developer >> job execution order
Thank you for answer. I think you understand me right. But I will try to
give more information.
First job has schedule created with following call:
it executes only when SQL Server Agent starts.
Second job has schedule created with following call:
235959
- this schedule executes every 2 hours starting from 5:30 (that is it fires
at 5:30, 7:30, 9:30, 11:30 .... 23:30).
My question is: what if SQL Server Agent starts at point of time near to
5:30 or 7:30 or 9:30 .... ? My intention is to never execute second job
before first job executed.
> I'm not sure I understand well the situation. If you can be more
> specific, that will help! however, with a lot of assumption on my side,
> I think there's no guarantee that the first job will be executed before
> the second. It depends on the thread scheduling.
>
>
> > On Fri, 16 Apr 2004 16:40:15 +0300, Igor Solodovnikov
> >
> >> I have two jobs. One has schedule which fires when Agent stars.
> >> Another has
> >> schedule which fires once per hour.
> >> Is it guaranteed that first job will be executed before second job
> >> when SQL
> >> server starts?
> >>
> >
> > Is my question so hard to answer? Or is it hard to understand it?
>
|
|
|
|
|
|
|