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

3 votes387 views1 answer
Two select sql
SQL
0 vote352 views1 answer
Oracle synonym procedure dblink
SQL
3 votes336 views1 answer
Difference sql vs mysql
SQL
0 vote356 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
3 votes369 views2 answers
Current year sql
SQL
38 votes363 views4 answers
Count sql
SQL
0 vote347 views1 answer
Changer un mot de passe mysql
SQL
0 vote355 views1 answer
Sqlite closes value
SQL
0 vote366 views1 answer
Copy value from one column to another postgres
SQL
0 vote371 views1 answer
Alter rename command in mysql
SQL