/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

2 votes326 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote279 views1 answer
Expose db in virtualbox
SQL
0 vote361 views2 answers
Insert data mysql with cmd
SQL
0 vote360 views10 answers
Sql statement checker corrector
SQL
1 vote332 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote328 views3 answers
Mysql connection string
SQL
0 vote366 views1 answer
How to check rollback status in oracle
SQL
0 vote328 views1 answer
Less than date query sqlachemy
SQL
2 votes345 views2 answers
Get all tables using like
SQL
0 vote324 views2 answers
Sql trigger difference between for and after
SQL