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

0 vote115 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote69 views1 answer
Mysql workbench search all tables
SQL
0 vote95 views1 answer
Create api project in visual studio 2019 and sql server
SQL
1 vote99 views1 answer
Sql alchemy with azuresql server
SQL
1 vote109 views1 answer
How to change owner in postgres
SQL
0 vote117 views1 answer
Sql server on mac m1
SQL
8 votes111 views3 answers
Connect python to mysql
SQL
0 vote113 views1 answer
View to table
SQL
0 vote121 views1 answer
Change redo log file size in mysql 5.6
SQL
10 votes108 views6 answers
Between sql
SQL