Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB schedule
Hi,
I tired it but I get following message:
SQL> exec dbms_job.isubmit(65,'jncdm_mexx_purfact2;',sysdate,'decode(to_char(sysdate,'DAY'),'FRIDAY' ,'trunc(sysdate + 1) + 15/24 + 00/(24 * 60)','trunc(sysdate + 1) + 13/24 + 40/(24 * 60)')'); BEGIN dbms_job.isubmit(65,'jncdm_mexx_purfact2;',sysdate,'decode(to_char(sysdate,'DAY'),'FRIDAY','tr
*ERROR at line 1:
SQL> Is there anything wrong with my syntax?
TIA Suresh
-- Message posted via http://www.oraclemonster.comReceived on Fri Feb 11 2005 - 05:13:52 CST