Is DTS possible to schedule like a job process?

EVH316

Hi,

Is DTS can automate like schedule job? How?

Thanks in advance

Sep 3 '08 #1

ck9663

Create your DTS package and schedule that package to run as necessary.

-- CK

Sep 3 '08 #2

Delerna

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.

Sep 4 '08 #3