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 vote246 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
5 votes220 views1 answer
Sort order on two columns sql
SQL
0 vote227 views1 answer
Oracle sql add column auto generated value
SQL
0 vote214 views3 answers
Convert sql query to python pandas
SQL
10 votes216 views3 answers
How to fetch first 5 characters in sql
SQL
3 votes218 views1 answer
Oracle rollback
SQL
0 vote255 views1 answer
Traccar mysql
SQL
15 votes213 views4 answers
How to get all tables in sql
SQL
1 vote284 views2 answers
Copy table in sql
SQL
2 votes206 views2 answers
Exec procedure pl sql
SQL