/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

11 votes315 views4 answers
Round in sql
SQL
10 votes168 views2 answers
Reset mysql root password mac
SQL
0 vote130 views2 answers
Azure sql-datenbank
SQL
0 vote149 views1 answer
Sql sum show 0 result
SQL
0 vote151 views2 answers
How to get the date from datetime in mysql
SQL
0 vote142 views1 answer
Ajax error exception handeling
SQL
0 vote173 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote131 views2 answers
Cambiar nombre tabla mysql
SQL
-2 votes136 views1 answer
Use of where in left join in mysql
SQL
14 votes166 views6 answers
Finding duplicate rows mysql
SQL