what abt the job_queue_processes and job_queue_interval parameters. Have u set them up ?
Secondly, is the job broken ?. Check out broken, failures for the job and the next_sec, next_date from dba_jobs.
Broken should be 'N' and failures should be 0.
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:
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;
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?