By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,574 Members | 1,977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,574 IT Pros & Developers. It's quick & easy.

Is DTS possible to schedule like a job process?

P: 26

Is DTS can automate like schedule job? How?

Thanks in advance
Sep 3 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 2,878
Create your DTS package and schedule that package to run as necessary.

-- CK
Sep 3 '08 #2

Expert 100+
P: 1,134
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

Post your reply

Sign in to post your reply or Sign up for a free account.