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 vote280 views1 answer
How to connect to mysql in ef 6
SQL
1 vote280 views1 answer
Not exists mysql
SQL
0 vote299 views1 answer
Ubuntu connect to mssql database
SQL
0 vote310 views1 answer
Mysql 5.7 in centos 7
SQL
0 vote306 views1 answer
Basic structure of sql expression having clause
SQL
0 vote291 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
1 vote296 views1 answer
Top 10 rows in mysql
SQL
37 votes309 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
2 votes278 views3 answers
Replace null in sql
SQL
14 votes303 views4 answers
Online sql compiler
SQL