/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

19 votes204 views6 answers
Mysql if null
SQL
0 vote180 views1 answer
Java spring boot connect to sql server
SQL
4 votes191 views1 answer
Create table if not exist in sqlite
SQL
0 vote275 views1 answer
Sql select max value for each group
SQL
0 vote199 views1 answer
Heidisql check how much space a row
SQL
0 vote181 views1 answer
Get who is hired in specific month in sql
SQL
0 vote184 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote214 views1 answer
Postgresql show owner of database
SQL
0 vote266 views2 answers
Fanyi
SQL
6 votes252 views2 answers
Mysql check auto increment value
SQL