One Time Immediate Job in Oracle

One Time Immediate Job can be created by using "dbms_job" and "dbms_scheduler" both.

1) One Time Immediate Job using dbms_job

  declare
    l_jobid number := null;
  begin
    dbms_job.submit 
    (
      job       =>  l_jobid,
      what      =>  'sp_proc;',
      next_date =>  sysdate,
      interval  =>  null
    );
    commit;
  end;
  /

Always remember to issue a COMMIT statement immediately after dbms_job.submit.


2) One Time Immediate Job using dbms_scheduler

  begin
    dbms_scheduler.create_job 
    (  
      job_name      =>  'One_Time_Job',  
      job_type      =>  'PLSQL_BLOCK',  
      job_action    =>  'begin sp_proc; end;',  
      start_date    =>  sysdate,  
      enabled       =>  TRUE,  
      auto_drop     =>  TRUE,  
      comments      =>  'one-time job');
  end;
  /

Related Posts:
- dbms_scheduler repeat_interval tip with create_schedule
- How to connect SQLPlus without tnsnames.ora
- SQL Interview Question Answers
- Oracle Database 12c New Features for Developers