Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DBMS_SCHEDULER.CREATE_JOB

DBMS_SCHEDULER.CREATE_JOB

From: Muthu Kumar G <g.muthukumar_at_gmail.com>
Date: 28 Dec 2005 21:37:16 -0800
Message-ID: <1135834636.107985.88940@z14g2000cwz.googlegroups.com>


what could be the error...

SQL> begin
  2 DBMS_SCHEDULER.CREATE_JOB (

  3  job_name =>'create_dir_test',
  4  job_type =>'executable',
  5  job_action => 'c:\winnt\system32\cmd.exe /c mkdir c:\test\test1',
  6 enabled =>true,auto_drop => true
  7 );
  8 commit;
  9 end;
 10 /
DBMS_SCHEDULER.CREATE_JOB (
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'DBMS_SCHEDULER.CREATE_JOB' must be declared
ORA-06550: line 2, column 1:

PL/SQL: Statement ignored Received on Wed Dec 28 2005 - 23:37:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US