Hi all,

I have the follow job will be executed as follow:

var j number
begin
dbms_job.submit
(
:j,
'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''TEST'',''COMPUTE'');
',sysdate,'sysdate+(90/(24*60*60))'
);
COMMIT;
end;


THIS Job suppose to start every 90 sec but for some reason, it doesn't start at all.

I did check the DBA_JOBS and the job is there. Any suggestions