Existing functionality.
Is there way to limit the runtime of a single job, a group
of jobs, or set a limit on the max execution time for all
jobs.

Home grown.
Can someone perhap provide some code snippets on how to
determine a jobs runtime, and/or kill it if it exceeds
some predetermined value in a table. I'm sure the
information is available, I see it in job hisotry. I just
don't know how to connect the dots.

Anyone doing this kind of automated monitoring?

You could insert a row into a table when the job starts and then updates
that rows when the job finishes. Youcould have another job that checks
every 5 minutes for any jobs with a start time entered but a end time of
NULL.

CREATE TABLE IsJobRunning(JobName varchar(128), StartTime smallDatetime,
EndTime smalldatetime NULL)



--
--

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


"ed" <mred_6 (AT) hotmail (DOT) com> wrote

In message <8d0801c432b5$f2e1cc10$a301280a (AT) phx (DOT) gbl>, ed
<mred_6 (AT) hotmail (DOT) com> writes

Yes. I've posted a zip file of my scripts and a brief explanation for
what I term my Job Monitor system here-

Sample Code & Packages
(http://www.sqldts.com/default.aspx?271)

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

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org