/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 vote157 views2 answers
Mysql switch case
SQL
2 votes125 views1 answer
Mysql auto increment jumping
SQL
5 votes162 views6 answers
Sql foreign key
SQL
1 vote129 views1 answer
Join first name and last name sql
SQL
0 vote154 views1 answer
Query archive mode
SQL
0 vote137 views1 answer
Print boolean in plsql
SQL
-1 vote136 views5 answers
Not in sql
SQL
1 vote139 views1 answer
Mysql query where in select
SQL
4 votes173 views1 answer
Mysql delete last row
SQL
0 vote138 views2 answers
Update all columns in one update
SQL