/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

2 votes139 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote133 views1 answer
Query builder doctrien return sql
SQL
0 vote125 views1 answer
Sql get number of days between two dates
SQL
3 votes124 views3 answers
Mysql select table names
SQL
0 vote124 views1 answer
Get foreign table names mysql
SQL
8 votes136 views10 answers
Sql
SQL
3 votes165 views1 answer
Query less than datetime sql
SQL
0 vote131 views1 answer
Sql server isnull function nor working count
SQL
4 votes210 views4 answers
Update select mysql
SQL
-1 vote164 views5 answers
Left join sql
SQL