/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 vote348 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
3 votes314 views1 answer
Sql several or
SQL
0 vote324 views1 answer
Sqlite referential integrity
SQL
2 votes336 views1 answer
Oracle list grants on procedure
SQL
0 vote323 views1 answer
Increment id in mysql
SQL
1 vote352 views1 answer
Psql connections
SQL
5 votes397 views3 answers
Sql limit offset
SQL
0 vote395 views1 answer
Wordpress make wp user in db
SQL
2 votes355 views2 answers
How to check database username and password in postgresql
SQL
3 votes360 views4 answers
Psql list tables in schema
SQL