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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.