Re: setting a alert on time out of a schedulted dts package
- From: "Helge C. Rutz" <news050424@xxxxxxxxxxxxxx>
- Date: Tue, 17 May 2005 17:00:13 +0200
Hi Kamal,
kamal wrote:
when you define a job for the DTS package and execute it through this job only, you can simply regularly check the job runtime with an additional job. See sp_help_job for details on the job info you get.what i want to do is a follows:
1. schedule a DTS package with timeout.but should not terminate the job. 2. when it timesout i want to send out a alert that the job has timed out
The only other way to do this I know is with an additional workflow inside of the DTS package.
You pass the allowed runtime to the package via global variable or define it statically and then check wether the last step of the main workflow has finished inside of the desired time.
Just loop between a SQLTask with "WaitFor Delay" statement to avoid constant polling and an activeX task which will loop back when main threat is still running, finish when main threat has finished to complete package, or send mail when package timed out.
Sending can be done with CDO inside of the activeX task.
To see how looping works and how you can check execution status go to www.sqldts.com look for workflows and also the simple looping example in the download section.
This would be an advanced feature, so you have to try a little bit ;-)
Helge
.
- Follow-Ups:
- References:
- Prev by Date: Re: API in VB code is rolling back SQL import but wizard does not
- Next by Date: Re: Please HELP! text import problems.
- Previous by thread: setting a alert on time out of a schedulted dts package
- Next by thread: Re: setting a alert on time out of a schedulted dts package
- Index(es):
Relevant Pages
|
