4 Replies Latest reply: Feb 10, 2014 1:29 PM by user3191291 RSS

Is there any way we can change the content of the body in email notification job?

user3191291 Newbie
Currently Being Moderated

I scheduled a several jobs running at midnight every day as the follows.

...

DBMS_SCHEDULER.CREATE_JOB(

      job_name            => 'Test_job1'

     ,job_type              => 'PLSQL_BLOCK'

     ,job_action            => 'DECLARE

                                      v_resultnum number;

                                      BEGIN

                                      ...

                                      END;'

     ,start_date            => SYSDATE

     ,repeat_inerval      => 'FREQ=DAILY;'

     ,enabled               => TRUE

     ,comments           => 'Email notification test.';

 

DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION (

      job_name            => 'Test_job1'

     ,recipients            => 'abc@abc.com'

     ,sender                => 'abc@abc.com'

     ,subject               => 'The scheduled jobs'

     ,body                   => '%event_type% occurred at %event_timestamp%. %error_message%

                                      Any concerns?'

     ,events                 => 'JOB_RUN_COMPLETED');

 

Somehow, I would like to add something like 'Please call me' in the body later on. How do I do that? Thanks.

 

cy

 


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points