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 vote259 views1 answer
Object Information
SQL
1 vote257 views1 answer
Sql only five first row
SQL
0 vote275 views1 answer
SQL Query to delete all the tables in a database
SQL
6 votes294 views3 answers
Mysql remove user privileges
SQL
-2 votes259 views1 answer
How to open database
SQL
-1 vote270 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
1 vote275 views1 answer
Moodle query item quiz
SQL
3 votes321 views2 answers
Oracle drop sequence
SQL
6 votes276 views1 answer
Postgres get size of database
SQL
6 votes232 views2 answers
Spring data jpa application.properties mysql
SQL