/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

1 vote320 views1 answer
What is intersect
SQL
1 vote326 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote304 views1 answer
Sql from null to not null
SQL
0 vote350 views1 answer
T-sql email validation
SQL
0 vote334 views1 answer
Mysql readable output
SQL
0 vote295 views1 answer
Jooq finding lastest value in table
SQL
0 vote350 views1 answer
Apex for oracle 11g
SQL
11 votes330 views2 answers
Turn off safe mode mysql
SQL
5 votes348 views2 answers
To date oracle
SQL
3 votes334 views4 answers
Stop MySQL
SQL