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 - 2002-01-17 : 11:13:51
|
| rich writes "I am trying to come up with a methodology that will allow me to run a DTS package based on the combination of an event success and a specific time. For example, upon completion of a particular DTS, have one or more DTS packages run at 3am the following day. Is my only option to write an ActiveX script to do this? HELP!" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-01-17 : 12:00:34
|
| Probably the easiest way is to schedule the DTS packages as jobs, to run at 3 am. You can then disable the jobs if the proper criteria aren't met; I think it's sp_disable_job or possibly sp_enable_job with a false parameter (I don't have Books Online with me now, you'll have to look it up). This will let you run the event and enable or disable the DTS jobs based on its success. |
 |
|
|
|
|
|
DTS execution on event