/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

0 vote261 views1 answer
Sql select lowest value row
SQL
2 votes259 views1 answer
Sql missing records from another table
SQL
0 vote217 views1 answer
Sql truncate table referencing itself
SQL
5 votes253 views1 answer
How to check nls format in oracle
SQL
10 votes258 views4 answers
How to alter table name in mysql
SQL
0 vote255 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote239 views1 answer
Ms Sql set us timezone
SQL
23 votes279 views4 answers
How to show all users in mysql
SQL
21 votes270 views1 answer
SQL cheat sheet pdf
SQL
1 vote254 views1 answer
Sql in array query
SQL