Post reply

Problem with SQL server 2005 jobs

  • June 10, 2008 at 7:13 am

    #72121

    Hi

    I have created two SQL server 2005 jobs through programatically, and i have attached a schedule to one job in the following way

    Schedule --> Job1 (Main Job ( is having one step to start the sub job) )

    Job2 (sub job) --> is having 4 steps inside..... it will be like , if one runs successfully then it should go to the next step.

    Now the problem is ==> I have two instances in my SQL server 2005, in one instance the jobs are running fine and its giving me the correct result which ever i want.

    In the second instance , all the steps in the sub job are trying to run at the same time, so first step is going fine, rest all are not running, but the status is showing that it was run successfully..( i m not getting the correct result)

    what could be the problem ...ihave noticed that all the properties of the two instances are similar...

    Can any one help in this issue

    Thanks in Advance

    Marella.

    Kindest Regards,

    AnanthaMarella

  • June 10, 2008 at 7:24 am

    #826624

    What are the steps?

    In the job properties, is each step set to move to the next step on completion? Are the jobs the exact same jobs in both instances?

    You could script out the jobs from both instances and compare the scripts.

  • June 10, 2008 at 2:41 pm

    #826981

    Steve Jones - Editor (6/10/2008)

    You could script out the jobs from both instances and compare the scripts.

    I second that. This is the EZist way to rule out the cause (assuming all other settings, like, permissions, etc, are correct.)

  • June 10, 2008 at 10:07 pm

    #827052

    Thanks for reply Steve and Grasshopper

    To Steve Jones

    Steps written like, if one is successfully run then go next step....etc.,

    Both the scripts are same ..

    Here the JOBS , SCHEDULE and JOB Steps created by external program (.NET 2005)

    To Grosshopper

    Every thing is same (settings, permissions etc ) in the two instances

    I have once more thing to ask here, how do i compare the properties of two SQL server 2005 instances.

    [font="Arial Black"]What i understood from the test is , in First SQL instance all the job steps are running sequentially, in the another instance all the job steps are trying to run in parallel.[/font]

    Kindest Regards,

    AnanthaMarella

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply