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