How to disable DTS scheduling

#1

Hi,
I'm taking over from a DBA who has a number of DTS packages defined
and scheduled. I need to stop some of the packages from executing, but
I can't find any place where I can do this. Any help appreciated.
Thanks
amit

#2

You just disable the scheduled job in SQL Agent that is associated with that
particular DTS Package.

--
Andrew J. Kelly SQL MVP

"Amit" <amitig (AT) hotmail (DOT) com> wrote

Quote:

Hi,
I'm taking over from a DBA who has a number of DTS packages defined
and scheduled. I need to stop some of the packages from executing, but
I can't find any place where I can do this. Any help appreciated.
Thanks
amit

#3

Thanks!

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

You just disable the scheduled job in SQL Agent that is associated with
that
particular DTS Package.

--
Andrew J. Kelly SQL MVP

"Amit" <amitig (AT) hotmail (DOT) com> wrote in message
news:2e07b60c.0411150724.23af7ff8 (AT) posting (DOT) google.com...
Hi,
I'm taking over from a DBA who has a number of DTS packages defined
and scheduled. I need to stop some of the packages from executing, but
I can't find any place where I can do this. Any help appreciated.
Thanks
amit

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to disable DTS scheduling

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How to disable DTS scheduling - 11-15-2004 , 09:24 AM

Re: How to disable DTS scheduling - 11-15-2004 , 10:47 AM

Re: How to disable DTS scheduling - 11-16-2004 , 08:08 AM