Is there a way to monitor all scheduled DTS jobs and restart the jobs
automatically when it faillS. If the job continues failing after being
restarted for several times then it must notify the responsible person. Is
there a tool that i can use with SQL to do this?

--
Message posted via http://www.sqlmonster.com

You can do that right in SQL Agent, specifically in the job itself. Go to
the advanced tab and you will see there are choices to redo the job if it
fails for x many tries. You can also set up alerts to notify people if it
fails.

--
Andrew J. Kelly SQL MVP


"mandla mkhwanazi via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote in
message news:f160dba1e42a4436aea5c5ce57b298bb (AT) SQLMonster (DOT) com...