/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

3 votes106 views1 answer
Sql double index
SQL
0 vote107 views3 answers
Database restoring error
SQL
0 vote111 views1 answer
Oracle select partition
SQL
1 vote122 views1 answer
Sql list all procedures
SQL
0 vote108 views1 answer
How to add boolean column in postgresql
SQL
0 vote108 views1 answer
Less than date query sqlachemy
SQL
10 votes114 views2 answers
Forgot my mysql password mac
SQL
2 votes111 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote115 views2 answers
Sql 2 way of select unique
SQL
0 vote109 views1 answer
Oracle remove line breaks
SQL