/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

6 votes145 views4 answers
How to remove unique key in mysql
SQL
0 vote145 views1 answer
Sql datediff db2
SQL
2 votes136 views2 answers
Function in sql
SQL
1 vote138 views1 answer
Oracle sql create view
SQL
0 vote303 views1 answer
Why do we need data structure in sql
SQL
1 vote167 views1 answer
Postgresql not in
SQL
23 votes150 views4 answers
How to show all users in mysql
SQL
17 votes143 views6 answers
Sql select distinct
SQL
13 votes139 views5 answers
Select last row mysql
SQL
8 votes176 views1 answer
See all users mysql
SQL