SQL Server Performance

setting up a Job agent

Discussion in 'Getting Started' started by shankbond, Feb 27, 2010.

  1. shankbond New Member

    Hi,
    I am little new to setting a job agent, I have created a job agent through SSMS it has two steps, I have done that as well, The job agent is also running successfully but I received a warning: The following job steps cannot be reached with the current job step flow logic: [step1] Is this the intended behavior?
    I am curious to know why the warning came?
    Can some one please Help me!
  2. satya Moderator

    Check the job step execution process, say if there are 3 steps then make sure step 1 completion goes to step 2 and then to step 3, see under STEP properties in this regard.
    Also you can find the information from SQL Books online by searching for SQLAgent and JOBS topic (tip).
  3. Subhash_Chandra New Member

    When we save changes in job steps, SQL Server check whether all steps are used or not. This is to avoide any any issue if we have miss any step by mistake. This warning will not occur if we have used all steps in any sequence.
    Regards,
    Subhash Chandra
    http://SQLReality.com/blog/
  4. Prashant Kumar New Member

Share This Page