467,917 Members | 1,385 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

Is DTS possible to schedule like a job process?


Is DTS can automate like schedule job? How?

Thanks in advance
Sep 3 '08 #1
  • viewed: 978
2 Replies
Expert 2GB
Create your DTS package and schedule that package to run as necessary.

-- CK
Sep 3 '08 #2
Expert 1GB
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.

Similar topics

29 posts views Thread by deko | last post: by
1 post views Thread by Bob | last post: by
7 posts views Thread by PawelR | last post: by
1 post views Thread by greg7224 | last post: by
8 posts views Thread by Marcus | last post: by
10 posts views Thread by Piotr Nowak | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.