dbms_submit to run dbms_stats failed
Hi all,
I am trying to schedule a job to run dbms_stats and it failed, below is my syntax:
var j number
begin
dbms_job.submit
(
:j,
'SYS.DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA_A',CASCADE=>TRUE);',
'SYS.DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA_B',CASCADE=>TRUE);',
'SYS.DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA_C',CASCADE=>TRUE);',
'SYS.DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA_D',CASCADE=>TRUE);',
SYSDATE,
'NEXT_DAY(trunc(sysdate),''SATURDAY'')+1/12'
);
COMMIT;
end;
any advises???? thanks