Right click on the DTS and select the "Schedule Package" option.
Follow the prompts, Its fairly intuitive.
Once completed you will find the schedule under
YourServersName/Management/SQL Server Agent/Jobs
in enterprise manager.
You can fine tune/edit the schedule timing etc there
You can enable/disable the schedule or even manually execute the schedule
There is Job run history, Job run outcome etc etc.
|