How to set SQL Server 2000 send an alert message if any of jobs fails or completes success

Hi!
I have several jobs scheduled to run every evening. Is there a way to
set SQL Server 2000 send an alert message if any of jobs fails or
completes successfully?"Zaur Bahramov" <zaur.bahramov@.mondialgroup.it> wrote in message
news:eGKQs4sqIHA.552@.TK2MSFTNGP06.phx.gbl...
> Hi!
> I have several jobs scheduled to run every evening. Is there a way to set
> SQL Server 2000 send an alert message if any of jobs fails or completes
> successfully?
>
For each job, you can send a notification. It must be configured in the
job.
The notification can be sent for On Success, On Failure or On Completion.
You would have to set this up for each job individually.
If you are looking for a more centralized management scenario, you would
probably have to code it.
Without thinking about it too much, I would probably create a new job that
is scheduled to run AFTER the other jobs should have completed.
I would use TSQL code to read the msdb database's jobs tables (sysjobhistory
IIRC) to determine the status of the jobs in question, put together the
email
and then send the email out.
Rick Sawtell|||Zaur
Create a job with three steps. First one is doing what you have defined
and goes to the second step if it failed. (Second step sends you email that
Job failed)
, if it succeded gooes to the third step (Second step sends you email that
Job succeded)
"Zaur Bahramov" <zaur.bahramov@.mondialgroup.it> wrote in message
news:eGKQs4sqIHA.552@.TK2MSFTNGP06.phx.gbl...
> Hi!
> I have several jobs scheduled to run every evening. Is there a way to set
> SQL Server 2000 send an alert message if any of jobs fails or completes
> successfully?
>