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

can anyone guide me on how to do this.

thanks in advance

kamal

Hi Kamal,

kamal wrote:
an additional job. See sp_help_job for details on the job info you get.

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

thanks it worked just fine

"Helge C. Rutz" wrote: