Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to go next ....

Author  Topic 

davidk
Starting Member

5 Posts

Posted - 2009-01-28 : 19:41:17
Hi,

I created 2 jobs in one database which was scheduled the 1st job at a particular time,

In the 1st job i am checking one condition like flag. If the column flag =1 in table1 then only it has to go to 2nd job, otherwise it should wait when the flag comes to 1.

How to go to 2nd job after successful run of the 1st job.

Can any one help me on this. I need a query or logic for this one

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-28 : 19:42:10
Why don't you just create one job and use multiple job steps?

You can start the other job via sp_start_job though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

davidk
Starting Member

5 Posts

Posted - 2009-01-28 : 20:11:24
ok, if i create in 2 steps then how to go to next step?

quote:
Originally posted by tkizer

Why don't you just create one job and use multiple job steps?

You can start the other job via sp_start_job though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog


Go to Top of Page
   

- Advertisement -