MSSQLTips

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.         

Hello,

      01. You can check job history of the first job to findout whether it has kicked off the second job, if so check the same for the second job to locate where the problem is.

      02. Go to the SQL Server Agent->Job activity Monitor-> right click -> View history

Thanks,

Narchand