/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

0 vote285 views2 answers
Raise notice in postgresql function
SQL
0 vote282 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
2 votes280 views1 answer
Update with join sql server
SQL
0 vote264 views1 answer
Comma seperated join mssql
SQL
0 vote285 views2 answers
Py sqlite if entry exists
SQL
1 vote272 views1 answer
Select if then postgresql
SQL
0 vote297 views3 answers
Condition in count sql
SQL
-1 vote262 views1 answer
Io
SQL
2 votes260 views1 answer
Date_format for time sql
SQL
1 vote272 views1 answer
Mysql dump specific tables
SQL