HI all,

If I have the following job to be scheduled to run, can I add another DBMS_UTILITY to analyze for the second schema let say TEST2 ???

var j number
begin
dbms_job.submit
(
:j,
'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''TEST1'',''COMPUTE'');',
SYSDATE,
'NEXT_DAY(trunc(sysdate),''SATURDAY'')+1/12'
);
COMMIT;
end;

Thanks