update_customer_payment.sql
- Read more about update_customer_payment.sql
- Log in to post comments
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'update_snapshots',
job_type => 'STORED_PROCEDURE',
job_action => 'UPDATE_SNAPSHOT',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly; byminute=5',
end_date => NULL,
enabled => TRUE
);
END
-- 10xe
DBMS_SCHEDULER.create_job (
job_name => 'update_invoice_positions',
job_type => 'PLSQL_BLOCK',
job_action => 'K.INVOICE;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly; byminute=0',
end_date