oracle job´´½¨³ö´í

ÔÚPL/SQLÖÐÖ´ÐÐÏÂÃæÓï¾ä£º
begin
  sys.dbms_job.submit(job => :job,
                      what => 'ClearAMSData;',
                      next_date => to_date('07-01-2010 03:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'sysdate+1');
  commit;
end;
/
½á¹û±¨´í£º¡°ora-01008 ²¢·ÇËùÓеıäÁ¿¶¼ÒѰ󶨡±£¬ÕâÊÇÔõô»ØÊ£¿Õâ¸öÓï¾äÊÇÎÒÓÃPL/SQLÊÖ¶¯ÉèÖÃÉú³ÉµÄ½Å±¾£¬ÎÒ°ÑËü¿½³öÀ´ÔÚÁíÍâÒ»¸ö»·¾³ÖÐÖ´ÐУ¬½á¹û±¨´í£¡

---

ÒýÓÃ

ÔÚPL/SQLÖÐÖ´ÐÐÏÂÃæÓï¾ä£º
begin
  sys.dbms_job.submit(job => :job,
                      what => 'ClearAMSData;',
                      next_date => to_date('07-01-2010 03:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'sysdate+1');
  commit;
end;
/
½á¹û±¨´í£º¡°ora-01008 ²¢·ÇËùÓеıäÁ¿¶¼ÒѰ󶨡±£¬ÕâÊÇÔõô»ØÊ£¿Õâ¸öÓï¾äÊÇÎÒÓÃPL/SQLÊÖ¶¯ÉèÖÃÉú³ÉµÄ½Å±¾£¬ÎÒ°ÑËü¿½³öÀ´ÔÚÁíÍâÒ»¸ö»·¾³ÖÐÖ´ÐУ¬½á¹û±¨´í£¡

ClearAMSData,