/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 vote172 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote176 views1 answer
Set open file limit mac catalina mysql
SQL
1 vote149 views1 answer
Postgresql update auto_increment value
SQL
0 vote172 views1 answer
T-sql check if data exists
SQL
10 votes184 views2 answers
Tsql merge example
SQL
0 vote180 views1 answer
Mysql DDL
SQL
2 votes159 views2 answers
Mysql all columns
SQL
1 vote162 views3 answers
Mysql Server Start
SQL
14 votes196 views3 answers
Oracle sql limit results
SQL
65 votes292 views6 answers
Sql add column to table
SQL