/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

0 vote194 views1 answer
Alter rename command in mysql
SQL
0 vote185 views1 answer
Sql pad left 0
SQL
0 vote173 views1 answer
Alter boolean column postgresql
SQL
0 vote232 views1 answer
Table structure in sql
SQL
0 vote178 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote194 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote186 views1 answer
Sql column contains special character
SQL
2 votes182 views2 answers
Get all tables using like
SQL
1 vote196 views1 answer
Best sql course
SQL
0 vote196 views1 answer
How to create a new db from dumb file mysql
SQL