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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-03 : 08:17:35
|
| Ditch writes "I need to conditionaly continue executing other DTS packages in a SQl Server job.I was thinking that if the remaining packages where to be put in a seperate Job, what I could do is test the condition at the end of 1 job and then either end the run Reporting Success or start the next job and report success for the existing job.If it is possible to handle this in Activex it would be perfect.If this is possible then could someone please explain how?Versions and stuff I use are as follows:Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3) " |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-03 : 08:24:49
|
| Why not create an SP to call run te packages.You can put the package names and paths in a table and also indicate the dependencies between them. Then when you run you can set the statuses and decide which to run next and even send out alarms and have processing windowsseehttp://www.nigelrivett.net/Scheduler.htmlTo start a job see sp_start_job in bol.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Is it possible to execute a SQL Server Job from an Activex Script?