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 |
|
hong_ma
Starting Member
37 Posts |
 Posted - 2006-02-02 : 16:38:25
|
| I have a DTS which has been scheduled to run every day. can I call another DTS from this DTS.how can I schedule a DTS which runs every quarter? Thanks! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-02 : 17:16:33
|
| >>can I call another DTS from this DTS.edit the DTS package and right click to Add Task - Execute Package Task>>how can I schedule a DTS which runs every quarterSchedule it monthly and run every 3 months----------------------------------'KH' |
 |
|
|
hong_ma
Starting Member
37 Posts |
Posted - 2006-02-02 : 22:32:38
|
| Thanks, how to run every 3 months? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-02 : 22:38:52
|
| right click your DTS package - Schedule PackageOccurs : MonthlyMonthly : The 1st Day of every 3 months----------------------------------'KH' |
|
|
|
hong_ma
Starting Member
37 Posts |
Posted - 2006-02-02 : 23:17:08
|
| Thanks a lot, I 'll try it tomorrow in the office because my computer at home doesn't have SQL server database |
|
|
|
|
|
|
DTS question