/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 vote294 views1 answer
Object Information
SQL
0 vote266 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
34 votes368 views6 answers
Alter table add foreign key mysql
SQL
6 votes289 views1 answer
Rank function in oracle with example
SQL
0 vote320 views1 answer
Sql order by except one row
SQL
31 votes306 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote299 views1 answer
Drop a field in psql django
SQL
0 vote311 views5 answers
Sql table intermédiaire
SQL
0 vote300 views1 answer
Foreign key multiple columns
SQL
45 votes375 views5 answers
Grant all privileges mysql
SQL