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 |
|
kakashi
Starting Member
7 Posts |
 Posted - 2006-02-07 : 00:15:29
|
| Hey guys,is there any way to set the schedule the DTS from store procedure?what i want to do is let client set the timer of the DTS Packpage.For example,DTS package runs every 4hrs, but one day in a week, client wants to run the package every 1hr or 2, depend on how busy it is. what i want to do is create a store procedure that allows the user to modify the scheduled time set for DTS package. So then whenever user wants to change the scheduled time, the user can simple call the store procedure sending in 1 parimeter (new time).Does anyone know how to do this? or is it possible? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-07 : 00:31:38
|
| sp_add_jobschedule. Refer to Books Online for detail----------------------------------'KH' |
 |
|
|
kakashi
Starting Member
7 Posts |
Posted - 2006-02-07 : 00:47:46
|
| thx khtan ^^i got it :) |
|
|
|
|
|
|
How to schedule DTS from store procedure?