Home › Oracle: submit job with user specified job number

Oracle: submit job with user specified job number 

Dr. Xi
Joined:
04/09/2007
Posts:
753

March 12, 2009 15:54:28    Last update: March 12, 2009 15:54:28
API: 
dbms_job.isubmit (
job       IN BINARY_INTEGER,
what      IN VARCHAR2,
next_date IN DATE,
interval  IN VARCHAR2 DEFAULT 'NULL',
no_parse  IN BOOLEAN DEFAULT FALSE);


Example: 
begin
   dbms_job.isubmit
      ( job       => '443',
        what      => 'monitor.check_waiting_jobs;',
        interval  => 'sysdate+15/1440'
      );
end;
/

Share |
| Comment  | Tags