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.
| Author |
Topic |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2006-08-30 : 17:09:04
|
| hi,How can i set on the job that if that fails then execuete different job instead.Thanks |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-08-30 : 17:44:51
|
| Write a DTS package define work flow, if success call Package1, failure call other package.Then schedule this package.With RegardsBSR |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-30 : 18:25:12
|
| I wouldn't use DTS for this. It can all be handled in job(s).Just create one job. Have all of the steps from both jobs in this one job. Control what to do next using the job step advanced tab.If you can't put the steps into one job, then add an extra job step to the primary job that does sp_start_job. Only have the job get to this job step if the previous job step fails.Tara Kizer |
|
|
|
|
|
|
execute job if first one fails