Oracle asynchronous update

-- 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 votes319 views1 answer
Sql server conection string
SQL
1 vote345 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote340 views1 answer
Oracle running queries
SQL
1 vote321 views1 answer
Get count by weekly pivot table sql server
SQL
17 votes374 views3 answers
Postgresql list users
SQL
1 vote264 views1 answer
Oracle compile schema
SQL
0 vote308 views1 answer
Minecraft duping allowed servers
SQL
3 votes320 views1 answer
Oracle user privileges
SQL
0 vote314 views1 answer
Get created time of database psql 8
SQL
0 vote334 views1 answer
Psql attribute cannot login
SQL