OraFAQ Forum: Enterprise Manager » how to notify via email when a job fails.

Home » RDBMS Server » Enterprise Manager » how to notify via email when a job fails. (Oracle 10g, Win 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to notify via email when a job fails. [message #296412]

Sat, 26 January 2008 12:13

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all

I have setup a job that runs every hour. the Job has a call to stored procedure that needs to be run every hour.

How to notify via email when a job fails..

we use oracle 10g
Win 2003 os

Thanks

Report message to a moderator

Re: how to notify via email when a job fails. [message #296414 is a reply to message #296412]

Sat, 26 January 2008 12:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://download-uk.oracle.com/docs/cd/B13789_01/appdev.101/b10802/u_mail.htm

Report message to a moderator

Re: how to notify via email when a job fails. [message #296415 is a reply to message #296412]

Sat, 26 January 2008 12:39

krblr
Messages: 24
Registered: April 2007
Location: MD

Junior Member

In short, this whole arrangement of being notified, will be done outside the jobs section. The owner of the job should let the administrator who wants to be notified permissions to view that job. The admin who wants to be notified will login to EM, go to preferences, create a rule for herself ( Laughing

), select the jobs tab, all jobs that she (just being silly today!) is eligible to view will appear, check them, and check the conditions to be notified for each job.

krblr

Report message to a moderator