I am not sure.. I am just asking.. Does this have anything to do with execution time and interval??? Say like, execution time for this particular analyze is 2 mins and interval is 90 secs. Does this cause the job to be terminated?? Juts a doubt..
I know I can use dbms_stat but I really like to make the dbms_job work as well but for some reason DBMS_JOB still have problem.
Below is the script of the user who own the package, but it kept saying unsuffiecient privilege on DBMS_UTILITY in the log file.
I don't get this
CREATE USER DB_ADMIN IDENTIFIED BY VALUES '910A6DB7DA7AC6FB'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
GRANT CONNECT TO DB_ADMIN WITH ADMIN OPTION
GRANT DBA TO DB_ADMIN WITH ADMIN OPTION
GRANT RESOURCE TO DB_ADMIN WITH ADMIN OPTION
ALTER USER DB_ADMIN DEFAULT ROLE CONNECT,
GRANT UNLIMITED TABLESPACE TO DB_ADMIN WITH ADMIN OPTION
GRANT EXECUTE ON SYS.DBMS_JOB TO DB_ADMIN
GRANT EXECUTE ON SYS.DBMS_UTILITY TO DB_ADMIN
Mike, sorry for the confusion. After asking the question to which you just answered, I realised you've specified your submit command in your initial post - that's why I have rewritten my question, but while I was doing that, you have allready answered to the question that is not visible any more. Oh, oh, oh, this must be confusing to anyone except you and me, I guess .
Anyway, can you run your WHAT parameter inside annonymous block as user DB_ADMIN?
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?