/SQL/Pl sql asynchronous procedure calls

Pl sql asynchronous procedure calls

-- 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 vote174 views1 answer
Sql commands in android
SQL
0 vote150 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote143 views1 answer
Replace string in whole database mysql stackoverflow
SQL
3 votes190 views3 answers
Mysql get table size
SQL
0 vote175 views1 answer
Sql server is not
SQL
3 votes126 views4 answers
Mysql decimal
SQL
3 votes163 views1 answer
Mysql cli connect with password
SQL
4 votes141 views1 answer
Oracle nls_date_format
SQL
0 vote138 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote134 views1 answer
Mysql select where field is a value
SQL