-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|