View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 09:26 AM
Muthu Kumar G
 
Posts: n/a
Default DBMS_SCHEDULER.CREATE_JOB

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

- Muthu Kumar.

Reply With Quote