Originally posted by mike2000
When I look into DBA_JOBS, I got the next time it will be executed however, on FAILURES=2 , what does it mean???
It means your job has allready run for two times and both times it was terminated because of some unhandled error. It will continue to resubmit itself after each failure (up to 16 times), each time with larger pause periode.

I'm almost certain the cause of the error has something to do with privileges of the owner of the job. Try the following, connected as the same user as the one who ownes the job:

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

If this reports any ORA-error, just fix it and your job will run fine.

My wild guess is that your user does not have direct execute priviledge to run that package. If that is so, you'll need to grant him:

GRANT EXECUTE ON sys.dbms_utility TO that_user;