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 votes276 views2 answers
Postgresql select all column names
SQL
2 votes254 views1 answer
Sql select min value from multiple columns
SQL
0 vote327 views1 answer
Drop view sql
SQL
1 vote284 views1 answer
Trim leading zeros in sql
SQL
0 vote266 views1 answer
Soql update query
SQL
0 vote301 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
1 vote265 views1 answer
Mysql select update same table
SQL
0 vote275 views2 answers
How to generate a unique random number in mysql
SQL
0 vote226 views1 answer
Import csv to mysql
SQL
2 votes298 views1 answer
Query to check cpu utilization in oracle database
SQL