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

0 vote198 views1 answer
Query by column for substring sql
SQL
2 votes246 views3 answers
Mysql kill
SQL
8 votes194 views1 answer
Sql remove leading spaces
SQL
0 vote201 views1 answer
R write csv without index
SQL
0 vote197 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote247 views1 answer
MySQL update with subquery
SQL
0 vote188 views1 answer
Inserted row count tsql
SQL
0 vote197 views1 answer
Oracle procedure chain step
SQL
0 vote155 views1 answer
Update set with join pl sql
SQL
0 vote268 views1 answer
Sql filter rows with condition
SQL