This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,903 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

DBMS_SCHEDULER not executing

SHAJ_SHAJIN
SHAJ_SHAJIN Member Posts: 38 Green Ribbon
edited Oct 11, 2022 1:54PM in MySQL Community Space

Hi All,

I have created a job in Oracle APEX but the job is not working. below is my code


BEGIN

 DBMS_SCHEDULER.create_job (

  job_name    => 'Template5',

  job_type    => 'PLSQL_BLOCK',

  job_action   => 'BEGIN Email_template; END;',

  start_date   => SYSTIMESTAMP,  

  repeat_interval => 'freq=Minutely;',

  end_date    => NULL,

  enabled     => TRUE,

  comments    => 'This is for Email template'

 );

END;

/


But when I run .run_job(below code) it is getting executed...


BEGIN 

DBMS_SCHEDULER.run_job (job_name => 'Template5') ;

END;


Could someone tell me how to solve this ?


Regards,

Andrew