Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Schedule

Status
Not open for further replies.

mousematt

MIS
Feb 5, 2001
102
0
0
GB
I have a dts package on my SQL2000 Server and was just wondering the best way to get this to run everyday. Any ideas
 
Simply right-click on the package within Enterprise Mgr and select Schedule Package....
 
If you need to modify the scheduled job you then need to go into the Enterprise Manager, locate the instance and then Management, SQL Server Agent (needs to be running!), then Jobs and you will see the job that you scheduled earlier. You can modify (or delete) it by right-clicking and selecting properties. You can modify the DTS job or change the schedule using the different tabs. A useful one is configuring notification to do a Net Send on success/failure of the job in the Notifications tab.

Hope this is of use.

B,
Galway,Ireland
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top