/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

6 votes199 views2 answers
Psql load dump
SQL
0 vote173 views1 answer
Time mysql w3
SQL
0 vote158 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote176 views1 answer
Run postgresql dump to csv
SQL
0 vote201 views1 answer
Sql datum formatieren
SQL
2 votes167 views1 answer
Get first 3 letters name in sql
SQL
0 vote169 views1 answer
Sql offfset
SQL
0 vote213 views1 answer
SQL Where-Klausel
SQL
0 vote183 views1 answer
Enable sql server full text indexing
SQL
0 vote183 views1 answer
Sql comand for removing data from table
SQL