1-- To call a procedure asynchronously, create a auto_drop job:
2BEGIN
3 DBMS_SCHEDULER.create_job(
4 job_name => 'My_JOB_NAME',
5 job_type => 'PLSQL_BLOCK',
6 job_action => 'BEGIN my_procedure(); END;',
7 start_date => systimestamp,
8 auto_drop => TRUE,
9 enabled => TRUE
10 );
11END;