DBMS_JOB

Hi all

I need to schedule a procedure using dbms_job.

I created it using the following script.

declare

   jobno number;
begin

   dbms_job.submit(jobno,'SP_MANUAL_REPLICATION;', sysdate,'sysdate+1');    commit;
end;

For some reason it not running at all.

Any thoughts? Received on Tue Nov 21 2000 - 11:43:17 CST