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

1 vote186 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote162 views1 answer
Rabbitmq service not starting
SQL
0 vote188 views1 answer
Oracle query archive mode
SQL
0 vote193 views1 answer
Oracle query to find schema you are working on
SQL
0 vote194 views1 answer
MySQL get all previous date record
SQL
1 vote192 views1 answer
Postgresql round double precision
SQL
0 vote195 views1 answer
Java sql insert return id
SQL
20 votes189 views5 answers
Sql show tables
SQL
5 votes188 views3 answers
Postgres show databases
SQL
8 votes173 views2 answers
Phpmyadmin default password
SQL