/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

26 votes147 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote146 views2 answers
Nosqlbooster query other collection
SQL
0 vote148 views1 answer
Hive batch drop table
SQL
3 votes158 views1 answer
Select sequence oracle
SQL
-2 votes146 views1 answer
How to open database
SQL
3 votes148 views2 answers
Oracle for loop
SQL
0 vote153 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
-1 vote137 views2 answers
On update cascade
SQL
0 vote177 views1 answer
Sql date with year
SQL
0 vote168 views1 answer
How to add mysql to path on termin after installation
SQL