identifier 'DBMS_SCHEDULER' must be declared
891407Sep 29 2011 — edited Sep 30 2011Hi Guys,
i am trying to create a job using dbms_schedular but it giving me following error.
BEGIN
dbms_scheduler.create_job (
job_name => 'test_job',
job_type => 'PLSQL_BLOCK',
job_action => 'begin a integer; b integer; sum(a,b); END;',
job_class => 'ADMIN',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=MINUTELY',
end_date => NULL,
enabled => TRUE,
comments => 'Job defined entirely by the CREATE JOB procedure.');
END;
/
ERROR at line 2:
ORA-06550: line 2, column 2:
PLS-00201: identifier 'DBMS_SCHEDULER' must be declared
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
NOTE: I have DBA grants .
Environment
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 on Linux
Can you guys please help where i am stuck or whats wrong with pl/sql block.