Oracle asynchronous query

-- 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 vote317 views1 answer
Ms Sql set us timezone
SQL
0 vote333 views1 answer
Use between operator in mysql
SQL
0 vote339 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote340 views1 answer
Postgresql heritage
SQL
0 vote355 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote324 views1 answer
How to to get current date and time in sql
SQL
2 votes340 views4 answers
Mysql select into new table
SQL
1 vote348 views1 answer
Oracle sql average
SQL
-1 vote339 views1 answer
What is in operator
SQL
0 vote333 views1 answer
Data types mysql vs postgresql
SQL