Re: Preventing Scheduled DTS Package from Running Multiple Instances

#1

Take a look at this thread:

http://groups.google.com/groups?hl=e... bl%26rnum%3D1

"Jeff Farquharson" <JeffFarquharson (AT) discussions (DOT) microsoft.com> wrote in
message news:937C2C0F-954A-467E-8B5F-0270812420A7 (AT) microsoft (DOT) com...

Quote:

I have a DTS package that is scheduled to run at 2:00 am every day. On
occassion it runs for more that 24 hours so I end up with two instances of
the package running at the same time. Because of the way that the process
is
architected, this is extremely undesirable, the second process can
overwrite
the results from the first.

Does anyone have a good technique for preventing a DTS from running if it
is
already running.

Any help would be much appreciated

#2

Thank you for your response

Thats the same solution that we came up with -- I was hoping for something a
little cleaner

"Ilya Margolin" wrote:

Quote:

Take a look at this thread:

http://groups.google.com/groups?hl=e... bl%26rnum%3D1

"Jeff Farquharson" <JeffFarquharson (AT) discussions (DOT) microsoft.com> wrote in
message news:937C2C0F-954A-467E-8B5F-0270812420A7 (AT) microsoft (DOT) com...
I have a DTS package that is scheduled to run at 2:00 am every day. On
occassion it runs for more that 24 hours so I end up with two instances of
the package running at the same time. Because of the way that the process
is
architected, this is extremely undesirable, the second process can
overwrite
the results from the first.

Does anyone have a good technique for preventing a DTS from running if it
is
already running.

Any help would be much appreciated

#3

Jeff,

You can aslo check if your job is still running:

sp_help_job @execution_status = 1, @job_name = ?

Ilya

"Jeff Farquharson" <JeffFarquharson (AT) discussions (DOT) microsoft.com> wrote in
message news:6B689C41-D0F5-4CD0-AB96-EC35E7599836 (AT) microsoft (DOT) com...

Quote:

Thank you for your response

Thats the same solution that we came up with -- I was hoping for something
a
little cleaner

"Ilya Margolin" wrote:

Take a look at this thread:

http://groups.google.com/groups?hl=e... bl%26rnum%3D1

"Jeff Farquharson" <JeffFarquharson (AT) discussions (DOT) microsoft.com> wrote in
message news:937C2C0F-954A-467E-8B5F-0270812420A7 (AT) microsoft (DOT) com...
I have a DTS package that is scheduled to run at 2:00 am every day.
On
occassion it runs for more that 24 hours so I end up with two
instances of
the package running at the same time. Because of the way that the
process
is
architected, this is extremely undesirable, the second process can
overwrite
the results from the first.

Does anyone have a good technique for preventing a DTS from running if
it
is
already running.

Any help would be much appreciated

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

Re: Preventing Scheduled DTS Package from Running Multiple Instances

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

Re: Preventing Scheduled DTS Package from Running Multiple Instances - 09-16-2004 , 07:53 AM

Re: Preventing Scheduled DTS Package from Running Multiple Instanc - 09-16-2004 , 09:35 AM

Re: Preventing Scheduled DTS Package from Running Multiple Instanc - 09-17-2004 , 08:15 AM