Sorry to come back to this topic again.

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
PROFILE DEFAULT
ACCOUNT UNLOCK
/
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,
DBA,
RESOURCE
/
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
/