Is there a way to send an email alert based on the current
run time of a job? For example, I want to send an alert
if a certain DTS job runs for more than 2 minutes. Is
this possible? If so, can anyone tell me how to set this
up?

Yes

Have a control table that accepts the Job Name, a StartTime and an end time.
You then have another job that executes every 1 minute that checks this
table for jobs that have a start time > 2 mins ago but no end time. This
then fires an Email



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Tim Savery" <Tim.Savery (AT) mbna (DOT) com> wrote