/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

5 votes298 views4 answers
Mysql on duplicate key update
SQL
1 vote277 views10 answers
Stack overflow
SQL
0 vote299 views1 answer
List column names of multiple tables psql
SQL
1 vote306 views1 answer
How to delete data from sql database in android
SQL
1 vote326 views1 answer
Mysql previous year
SQL
1 vote294 views1 answer
Oracle duration between timestamps
SQL
0 vote318 views1 answer
Mysql user set plugin
SQL
3 votes286 views1 answer
Oracle rollback
SQL
4 votes281 views2 answers
Dbms_scheduler stop job
SQL
0 vote309 views1 answer
How to select all fieldsin a soql query
SQL