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

2 votes156 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote143 views1 answer
Sql get guid
SQL
25 votes150 views3 answers
Mysql command show tables
SQL
4 votes199 views2 answers
Sql select except null
SQL
0 vote100 views1 answer
Finish transaction sql
SQL
42 votes225 views6 answers
Rename table sql server
SQL
0 vote135 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
0 vote153 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
5 votes163 views3 answers
Show indexes mysql
SQL
0 vote163 views1 answer
How to get parent and child record in single query using sql
SQL