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

1 vote349 views2 answers
Sql select only first occurrence
SQL
0 vote319 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes327 views1 answer
Convert series number to date in sql
SQL
0 vote361 views1 answer
How to access to mysql without root
SQL
0 vote343 views1 answer
Sql server express download
SQL
0 vote426 views2 answers
Sql query print strings and int
SQL
4 votes367 views2 answers
Installing sql on ubuntu
SQL
11 votes344 views4 answers
Round in sql
SQL
11 votes341 views2 answers
Having clause
SQL
4 votes351 views2 answers
Oracle last day of month
SQL