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
 SQL Server Administration (2005)
 Jobs

Author  Topic 

honey_191
Starting Member

49 Posts

Posted - 2008-02-09 : 23:35:51
I have to create 2 jobs,The first job has 2 steps,in the last step of the first job,i have to call the 2nd job,How????Can any body help me?

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2008-02-10 : 00:38:32
http://msdn2.microsoft.com/en-us/library/ms186757.aspx

sp_start_job
{ [@job_name =] 'job_name'
| [@job_id =] job_id }
[ , [@error_flag =] error_flag]
[ , [@server_name =] 'server_name']
[ , [@step_name =] 'step_name']
[ , [@output_flag =] output_flag]




Poor planning on your part does not constitute an emergency on my part.

Go to Top of Page
   

- Advertisement -