|
|
||||||
|
#1
02-24-05, 10:23 AM
|
|
|
|
|
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? |
|
|
|
#2
02-24-05, 01:54 PM
|
|
|
|
|
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. |
|
|
| Similar Threads | |
| Monitoring Jobs Okay, I got the bright idea on my SS 2000 SP4 server to monitor jobs using a script to create a temp table and put the results into it using an exec statement. (See script... |
|
| Monitoring and Reporting of NTBACKUP jobs Hi all, First - thanks to all here who have helped me get my first SBS2003 installation up and running. Really getting there now, using this internally to run my business... |
|
| Jobs monitoring hi, there is a script/docs in net abt monitoring the backups. How abt for sechdeuled jobs? just wanted to know whether it was successful on the day it is scheduled to... |
|
| Monitoring the print jobs.... Hello everybody, I'm trying to monitor the Windows printer queue. It is very importan for my app to gather the paper size and if the printing is color or monochrome. I... |
|
| schedule jobs How can i create a stored procedure that runs a sql schedule or update the date and time for a schedule job. |
|
|
All times are GMT. The time now is 12:09 AM. | Privacy Policy
|
DTS/Schedule Jobs monitoring