Hi,
I have a DTS package that runs at different times of the day. I have
set this up as different jobs. The function of these jobs is to gather
data from a server in our corporate domain and write it out as a text
file for my other applications to process. Sometimes, the host server
has some issues like open cursors etc., which leave my jobs just
hanging and not fail out. I know that these jobs do not take more than
10 mins to complete. Based on this fact, is there a way to set
thresholds on the duration of the jobs? If I could set a threshold and
make it fail out then, I would be able to get notifications about it.
Any help in this regard would be appreciated.
Thanks,
-Srinidhi

What about

at the start of your packages (jobs that fire packages) you write a row to a
log table. You have a watcher job that looks at this table every 1 minute
to check for open jobs and the open duration. At the end of each job (DTS
package) you write the completed status to the relevant job. If your
watcher job finds a job still running after n minutes then it can take
action from there.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Srinidhi" <srinidhi_3 (AT) yahoo (DOT) com> wrote