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

17 votes333 views6 answers
Mysql import sql file
SQL
1 vote336 views1 answer
Minus vs intersect in sql
SQL
0 vote336 views1 answer
Postgresql if else endif
SQL
0 vote383 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
1 vote344 views1 answer
How to update date add hours in postgresql
SQL
1 vote347 views3 answers
Mysql Server Start
SQL
1 vote336 views3 answers
Reset sql primary key
SQL
0 vote387 views1 answer
Snowflake drop column
SQL
7 votes371 views1 answer
Query postgres delete duplicates
SQL
0 vote353 views1 answer
Postgres drop type
SQL