Running SQL server agent job steps based on condition

Posted on 2012-08-15
Last Modified: 2012-11-12
I have a created a sql server job with two steps. I need to run step one based on a condition. If the condition doesn't staisfy run another step. (each step conatins an ssis package to run)

To implement this, I have created another step in the job which runs first with the condition.
 if the condition staisfies -set on success- go to step one. if the condition fails -raiseerror-set on failure- go to step2

Is there any other way to do this other than using onsucess and onfailue? If the condition does not satisfy, I do not want to use raiseerror. It should just execute step 2
Question by:MRPT
    LVL 16

    Expert Comment

    You could do this with a single parent package which executes the child packages using the execute package component. based up these criteria.

    The only condition based criteria you have in a SQL Server agent job is success, failure and completion (Regardless of exit code).
    LVL 25

    Accepted Solution

    Both ways are good. With your way of job, you can just add the condition in the first step and if it satisfies, run the package with DTSexec else run another with DTSexec. But you need to maintain another tracking table to find out what run if something goes wrong.
    Your current way looks more organized to me.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now