Oracle Jobs: Unterschied zwischen den Versionen
Aus PPwiki
Schild (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „== axs,öx ==“) |
Schild (Diskussion | Beiträge) (→axs,öx) |
||
| Zeile 1: | Zeile 1: | ||
| − | == | + | == Job nur tagsüber ausführen == |
| + | <pre> | ||
| + | <begin | ||
| + | DBMS_SCHEDULER.create_job ( | ||
| + | job_name => 'Integration_export', | ||
| + | job_type => 'PLSQL_BLOCK', | ||
| + | job_action => 'integration_export;', | ||
| + | start_date => SYSTIMESTAMP, | ||
| + | enabled => TRUE, | ||
| + | repeat_interval => 'freq=daily; byhour=6,8,10,12,14,16,18; byminute=0; bysecond=0'); | ||
| + | end; | ||
| + | / | ||
| + | </pre> | ||
Version vom 25. Januar 2021, 08:04 Uhr
Job nur tagsüber ausführen
<begin
DBMS_SCHEDULER.create_job (
job_name => 'Integration_export',
job_type => 'PLSQL_BLOCK',
job_action => 'integration_export;',
start_date => SYSTIMESTAMP,
enabled => TRUE,
repeat_interval => 'freq=daily; byhour=6,8,10,12,14,16,18; byminute=0; bysecond=0');
end;
/
