/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 vote336 views1 answer
Mysql delete entire row on condition
SQL
0 vote287 views1 answer
Write sql query to show the details start from digit
SQL
1 vote272 views1 answer
Postgresql convert text to float
SQL
0 vote311 views1 answer
Mysql best varchar length size
SQL
0 vote279 views1 answer
Implicit inner join table alias with id values
SQL
0 vote284 views1 answer
Get who is hired in january in sql
SQL
0 vote297 views1 answer
Create relationship with betwen two tables in postgersql
SQL
8 votes379 views3 answers
Find table for column name in sql
SQL
2 votes351 views1 answer
Find column in all stored procedures sql server
SQL
3 votes301 views4 answers
Order by desc postgres
SQL