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

0 vote350 views1 answer
Mysqldump: error:
SQL
0 vote325 views1 answer
Mysql show category once count how many products
SQL
0 vote283 views1 answer
Mariadb list tables
SQL
4 votes304 views1 answer
Postgresql change default value
SQL
0 vote325 views1 answer
Get enginge db mysql
SQL
0 vote321 views1 answer
SQL authentication error
SQL
4 votes318 views2 answers
Convert utc to est sql
SQL
-1 vote371 views1 answer
Difference berween database and data base management system
SQL
0 vote307 views1 answer
The local psql command could not be located
SQL
0 vote305 views1 answer
Object Information
SQL