Database Administration (MOSC)

MOSC Banner

DBMS jobs doubts

edited Oct 15, 2012 1:00AM in Database Administration (MOSC) 7 commentsAnswered
Hi All,

Greetings of the day.  The database version is 11.2.0.2

In dev db Issue is whenever a job fails we get a notification from the db and that sender address is same as  Production

When i checked the ddl of the job  i couldnt see the sender address .

and querying select sender,job_name, recipient, event, filter_condition from dba_scheduler_notifications;  also shows sender address as dev@dev.com but all mails received are from prod@prod.com

DDl of the job is

BEGIN
dbms_scheduler.create_job('"IN_JOB"',program_name=>'"IN_PROG"',
schedule_name=>'"IN_SCHEDULE"',job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center