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

0 vote353 views1 answer
Qt qsql check if table exist
SQL
-1 vote313 views1 answer
Oracle db list usernames
SQL
25 votes348 views5 answers
Uninstall mysql ubuntu
SQL
1 vote386 views1 answer
Get current date in pyspark sql
SQL
1 vote347 views2 answers
How to enable error squiggles in vs code
SQL
0 vote383 views1 answer
Split string by comma in sql server
SQL
0 vote351 views1 answer
ORACLE PARSE STRING
SQL
0 vote352 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
12 votes354 views4 answers
Mysql get date difference in hours
SQL
1 vote339 views1 answer
Give a column name to values generated from case statement in sql
SQL