Suppress errors in DTS SQL Task

#1

Hi. I have the following line of code in at sql task in my DTS package:
msdb.dbo.sp_start_job @job_name='myJob'

If this line returns an error (as it will if the job is already running) I
would like to ignore the error and keep the package going. As it is, the
entire task will fail if this one line fails. Is there a way to turn off
errors or ignore an error that arises?

Thanks,

Kevin

#2

In article <eMiLUQfXDHA.2592 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Kevin Thomas
<NOSPAMKevinRobertThomas2000 (AT) NOSPAMhotmail (DOT) com> writes

Quote:

Hi. I have the following line of code in at sql task in my DTS package:
msdb.dbo.sp_start_job @job_name='myJob'

If this line returns an error (as it will if the job is already running) I
would like to ignore the error and keep the package going. As it is, the
entire task will fail if this one line fails. Is there a way to turn off
errors or ignore an error that arises?

Thanks,

Kevin

The entire package will only fail immediately if you have set the
package property "Fail on first error" on. Assuming this option is off
you could use an On Complete workflow to your next task to keep going.

Alternatively you could query the job status and see if it is running
already, and only if it is idle, then call sp_start_job. This would be
my preferred method as any other unexpected errors will still be visible
to you.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

#3

Thanks Darren,

Kevin

"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:rz6uFQJrPrN$Ew7+@sqldts.com...

Quote:

In article <eMiLUQfXDHA.2592 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Kevin Thomas
NOSPAMKevinRobertThomas2000 (AT) NOS...mail (DOT) com> writes
Hi. I have the following line of code in at sql task in my DTS package:
msdb.dbo.sp_start_job @job_name='myJob'

If this line returns an error (as it will if the job is already running)
I
would like to ignore the error and keep the package going. As it is, the
entire task will fail if this one line fails. Is there a way to turn off
errors or ignore an error that arises?

Thanks,

Kevin

The entire package will only fail immediately if you have set the
package property "Fail on first error" on. Assuming this option is off
you could use an On Complete workflow to your next task to keep going.

Alternatively you could query the job status and see if it is running
already, and only if it is idle, then call sp_start_job. This would be
my preferred method as any other unexpected errors will still be visible
to you.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

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

Suppress errors in DTS SQL Task

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

Suppress errors in DTS SQL Task - 08-08-2003 , 04:28 PM

Re: Suppress errors in DTS SQL Task - 08-10-2003 , 04:06 PM

Re: Suppress errors in DTS SQL Task - 08-13-2003 , 04:35 PM