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 vote314 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote357 views3 answers
CONTACT FORM SQL
SQL
1 vote358 views1 answer
Epoch time converter in snowflake
SQL
0 vote354 views1 answer
Prodection ready postgres database step by step
SQL
0 vote332 views1 answer
What is between keyword used for
SQL
14 votes313 views2 answers
How to auto increment in sql
SQL
-1 vote362 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote324 views1 answer
Sql server delete records with specific date
SQL
0 vote376 views1 answer
Move table to a different schema
SQL
7 votes299 views1 answer
Mysql load data infile csv
SQL