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 vote244 views2 answers
Sql trigger difference between for and after
SQL
6 votes226 views1 answer
What is where clause in sql
SQL
0 vote276 views1 answer
Hibernate dialect property xml for mysql 8
SQL
-1 vote269 views2 answers
Sql search all tables for attributes
SQL
0 vote223 views2 answers
Check mysql timezone
SQL
2 votes243 views1 answer
Add new column not null sql server
SQL
1 vote232 views1 answer
Oracle create index if not exists
SQL
1 vote243 views3 answers
Alter schema sql server
SQL
0 vote222 views1 answer
How to check if there is no database schema
SQL
4 votes271 views3 answers
Postgres drop all tables
SQL