/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 vote253 views1 answer
Mysql procedure between two tables
SQL
1 vote271 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote267 views1 answer
What does leave do in mysql
SQL
4 votes288 views1 answer
Postgres delete last row
SQL
0 vote268 views1 answer
What is initial catalog in sql connection string
SQL
0 vote294 views1 answer
Typical max-connect-errors mysql
SQL
0 vote271 views4 answers
What is unique key in sql
SQL
3 votes238 views1 answer
Oracle detect invalid password
SQL
0 vote258 views1 answer
Placements hackerrank solution
SQL
11 votes245 views2 answers
Import sql file laravel cmd
SQL