/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 vote281 views1 answer
Get last updated row sql server
SQL
0 vote284 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote308 views1 answer
Oracle table privileges
SQL
0 vote281 views1 answer
Which MySQL data type to use for storing boolean values
SQL
3 votes267 views1 answer
Difference sql vs mysql
SQL
-1 vote296 views2 answers
First letter capital in mysql query
SQL
1 vote311 views3 answers
How to create a table structure from another table in mysql
SQL
-1 vote234 views2 answers
Datetime sql server week
SQL
0 vote290 views1 answer
Mysql select field if condition
SQL
6 votes281 views2 answers
Join vs union
SQL