SQSERVER 2005 Job Scheduling 2

[manmaria]

I got few Jobs under SQLSERVER Agent and I want to execute them in order. What I am doing is creating a new job to execute all these jobs in order but I do not see an option for sql server agent jobs and what I see the options are like 'ActiveX Script', or 'AS Query' or 'IS Package' or 'TSQL script' but not any sql server Agent Jobs.

How do I schedule the jobs?

Thanks in advance
Mari

 

[manmaria]

I also tried by creating a package to execute the SQL Server Agent jobs in order like executing the second job after the Successful completion of the First job. But looks like they all are executing at the same time even I mentioned the constraints.

Thanks

 

[mrdenny]

When you start a job the T/SQL that actually starts the job doesn't wait for the job to finish. It simply reports that the job is started and moves on to the next statement.

Your best bet will be to move all the jobs into a single job with each job as a step in the main job.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[manmaria]

Thanks. I tried to do that but there is no 'type' for the sql server agent jobs.

 

[rac2]

Each of your jobs has steps. Move all of the steps into one job.

 

[manmaria]

Thanks. That means I have rewrite the job again since we already created the list of jobs already now we want to link these jobs together but not rewriting.

Thanks though,

 

[mrdenny]

You have to rewrite. You can not make one job a step of another job in the way you describe.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com