Oracle asynchronous procedure

-- To call a procedure asynchronously, create a auto_drop job:
BEGIN
    DBMS_SCHEDULER.create_job(
            job_name => 'My_JOB_NAME',
            job_type => 'PLSQL_BLOCK',
            job_action => 'BEGIN my_procedure(); END;',
            start_date => systimestamp,
            auto_drop => TRUE,
            enabled => TRUE
        );
END;

Similar codes

15 votes204 views2 answers
Install mysql 8 ubuntu 18.04
SQL
1 vote210 views1 answer
Mysql query bulk insert
SQL
2 votes236 views1 answer
How to select from mssql
SQL
-1 vote218 views1 answer
Mysql order by on condition
SQL
3 votes220 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
19 votes191 views6 answers
Laravel sql query
SQL
4 votes201 views4 answers
Print pl sql
SQL
4 votes213 views1 answer
Mysql not equal
SQL
2 votes340 views5 answers
Unique in sql server
SQL
0 vote205 views1 answer
Mysql procedure between two tables
SQL