/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 votes220 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
49 votes209 views6 answers
Get duplicate records in sql
SQL
0 vote221 views1 answer
Update having mysql
SQL
8 votes203 views5 answers
Grant permission in postgres
SQL
0 vote213 views1 answer
Order child below the parent in mysqli
SQL
5 votes208 views3 answers
Mysql extract month from date
SQL
1 vote197 views1 answer
Mysql monthname
SQL
0 vote524 views1 answer
Sql field equals multiple values
SQL
1 vote191 views1 answer
Sql only five first row
SQL
0 vote208 views1 answer
Mysql pad zeros
SQL