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 vote270 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote276 views1 answer
Mysql to get column name in database
SQL
0 vote272 views1 answer
Mysql grant user wildcard database
SQL
51 votes384 views6 answers
Change column name sql
SQL
1 vote315 views1 answer
Oracle show execution plan
SQL
1 vote322 views1 answer
Oracle columns table
SQL
1 vote276 views1 answer
Mysql return text after a final full stop
SQL
2 votes301 views2 answers
Spring where to put the data sql
SQL
0 vote264 views1 answer
How to connect to mysql in ef 6
SQL
0 vote289 views1 answer
Can we rollback in sql
SQL