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 |
|
nguyenl
Posting Yak Master
128 Posts |
 Posted - 2008-01-31 : 19:49:34
|
| I have successfully created a DTS package, and would like to use SQL Server Job Agent to schedule it (instead of right-clicking on the package and scheduling a plan because the dates that I need to run this package are not fixed). How would I proceed? I am using SQL Server 2000.Thanks... |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-31 : 19:59:17
|
| right clicking and scheduling the package creates a sql agent job. you can then go into that job and modify the schedule.-ec |
 |
|
|
nguyenl
Posting Yak Master
128 Posts |
Posted - 2008-02-01 : 11:14:40
|
| Thanks EC.....didn't realize it was that simple.... |
|
|
|
|
|
|
DTS and SQL Job Agent