/SQL/Pl sql asynchronous procedure calls

Pl sql asynchronous procedure calls

-- 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 vote349 views1 answer
Sql developer sql worksheet not showing
SQL
8 votes393 views3 answers
Postgres database sizes
SQL
1 vote365 views1 answer
Oracle sequence last_number
SQL
0 vote370 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
2 votes369 views2 answers
Postgres trigger insert into another table
SQL
4 votes360 views6 answers
Second max salary in sql
SQL
0 vote351 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
4 votes364 views1 answer
Alter session set nls_date_format
SQL
0 vote334 views1 answer
Replace null value within column mysql
SQL
1 vote299 views1 answer
Ms sql how to see active job current run time
SQL