/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 vote119 views1 answer
Pl sql ptint
SQL
0 vote123 views1 answer
Contact mysql column field
SQL
0 vote116 views1 answer
Turn on foreign keys check mysql
SQL
5 votes122 views1 answer
How to get all dates in a month in oracle
SQL
6 votes125 views4 answers
Mysql update set
SQL
0 vote119 views1 answer
Mysql get nested records
SQL
11 votes118 views3 answers
Sql line numbers
SQL
5 votes111 views4 answers
Describe table postgres
SQL
8 votes122 views1 answer
Oracle find text in functions
SQL
0 vote109 views1 answer
Select top 3 sql
SQL