I would like to schedule a job which notifies me and my team members when ever some particular jobs in a schema gets failed or disabled. I heard that there is oracle default program, 'DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION' which will do that. But i couldnt understand how to do that and how to get started with that. Can anyone plz guide me how to do that? Thanks in advance.
I am using Oracle 11g.
Hi I tried with ur link in the following way
But i am getting this error
ORA-27469: EMAIL_SERVER is not a valid scheduler attribute
ORA-06512: at "SYS.DBMS_ISCHED", line 3084
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2210
ORA-06512: at line 2
What will be the reason? Moreover i couldnt able to find 'USER_SCHEDULER_NOTIFICATIONS' table in my DB. Can anyone help me plz
I am not sure but I think you should talk to either your DBA or your network guy. Normally, the port number should be at the end, something like
As far as the table USER_SCHEDULER_NOTIFICATIONS, you should be able to see it if you log on sys.