/SQL/Pl sql asynchronous procedure calls

Pl sql asynchronous procedure calls

-- 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

2 votes275 views1 answer
Oracle apex who is connected
SQL
1 vote290 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
13 votes460 views4 answers
Sql joining 3 tables
SQL
1 vote266 views1 answer
Create procedure with encryption
SQL
0 vote259 views1 answer
Default column value in sql same as other column
SQL
1 vote284 views1 answer
Trim leading zeros in sql
SQL
0 vote275 views1 answer
How to find columns with null values in sql
SQL
0 vote297 views1 answer
Default order by in mysql
SQL
-1 vote311 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote289 views1 answer
Sql set data from a select query to a temp table and insert
SQL