Re: job execution order

From: Cherdian Lim (limcy_at_infolink.co.id)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 11:45:52 +0700

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.

Igor Solodovnikov wrote:

> On Fri, 16 Apr 2004 16:40:15 +0300, Igor Solodovnikov
> <siv@helpco.kiev.ua> wrote:
>
>> 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?

Relevant Pages

  • Re: How to check status of scheduled job
    ... Then, schedule that ... app to run. ... There is a dependency with this, the second job cannot start ... until the first job finishes running. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: job execution order
    ... First job has schedule created with following call: ... it executes only when SQL Server Agent starts. ... Second job has schedule created with following call: ...
    (microsoft.public.sqlserver.programming)
  • Follow-up query on 1099Misc confusion
    ... either a schedule E, Schedule C, or Form 4835, none of which seems ... (She plans not to itemize and just take the standard deduction) ... her first job, doing the computer work at home which she often does and then ...
    (misc.taxes)
  • Re: job execution order
    ... > schedule which fires once per hour. ... > Is it guaranteed that first job will be executed before second job when ... > SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: job execution order
    ... > schedule which fires once per hour. ... > Is it guaranteed that first job will be executed before second job when ... > SQL ...
    (microsoft.public.sqlserver.programming)