/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

1 vote238 views1 answer
Sql server kill all connections
SQL
0 vote203 views1 answer
Select all domains of database firbird
SQL
1 vote252 views1 answer
Oracle truncate partition
SQL
0 vote243 views2 answers
How covert into int in maria db
SQL
0 vote262 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
-1 vote236 views2 answers
Postgresql get last 10 records
SQL
0 vote244 views1 answer
Drop CHECK constraint sql
SQL
2 votes237 views1 answer
While loop sql
SQL
23 votes227 views3 answers
Mysqldump
SQL
1 vote258 views1 answer
Trim leading zeros in sql
SQL