/SQL/Sql asynchronous stored procedure call

Sql asynchronous stored procedure call

-- 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 vote122 views1 answer
How to fetch alternate records from two tables
SQL
0 vote113 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
2 votes120 views3 answers
How to get second highest salary in each department in sql
SQL
19 votes119 views3 answers
How to change column type psql
SQL
10 votes68 views1 answer
Oracle view dependencies
SQL
3 votes143 views1 answer
Apex set debug level
SQL
0 vote125 views1 answer
Count number of entires by months sql
SQL
12 votes149 views6 answers
How to install sqlite3 in python
SQL
0 vote123 views1 answer
How to add timestamp column in mysql
SQL
22 votes168 views4 answers
Mysql date format
SQL