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. |