SQL> variable v_jobnum number
SQL> Begin
2 DBMS_JOB.SUBMIT(:v_jobnum, 'analyze;', sysdate, 'sysdate +1');
3 End;
4 /
Begin
*
ERROR at line 1:
ORA-06550: line 1, column 93:
PLS-00201: identifier 'ANALYZE' must be declared
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 131
ORA-06512: at line 2