Why my apex jobs doesn't work?
APEX 4.0.2.00.07
Oracle 10g/10.1.2.0.0
I submmit the jobs successfully, which used for sending email daily, see below:
DECLARE
l_sql VARCHAR2(4000);
l_job NUMBER;
BEGIN
l_sql := 'BEGIN Sendemail; END;';
l_job := APEX_PLSQL_JOB.SUBMIT_PROCESS(
p_sql => l_sql,
p_when => sysdate + 1,
p_status => 'send email');
END;
I test the procedure "Sendemail" and receive the mail successfully. but next 2 days didn't receive any mail.
I could see the job through apex_plsql_jobs view, and the job's system status is "complete".
Please help me. thanks in advance.
Edited by: Yong Huang on May 23, 2012 10:09 PM