DBMS_JOBS DOES NOT WORK

[jmodic]

Connecting as DB_ADMIN and isue the following:

BEGIN
DBMS_UTILITY.ANALYZE_SCHEMA('TEST','COMPUTE');
END;
/

Does it raise any errors? Like "ORA-20000: Insufficient privileges..."? If so, you'll need to grant ANALYZE ANY system privilege to your user DB_ADMIN.

If this runs succesfully in an anonymous block there is no reason why it shouldn't run inside a job.

[Edited by jmodic on 10-08-2002 at 03:44 PM]