Benutzer-Werkzeuge

Webseiten-Werkzeuge


dba:oracle_scheduler_12c_external_scripts

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
dba:oracle_scheduler_12c_external_scripts [2019/09/20 14:17]
gpipperr [OS User Account hinterlegen, inkl. Domain!]
dba:oracle_scheduler_12c_external_scripts [2019/09/20 14:35]
gpipperr [OS User Account hinterlegen, inkl. Domain!]
Zeile 312: Zeile 312:
 <code sql> <code sql>
  
-select OUTPUT from user_scheduler_job_run_details WHERE job_name = 'ETL_JOB';;+select ERRORS 
 +   ,  OUTPUT 
 +   ,  BINARY_ERRORS 
 +   ,  BINARY_OUTPUT 
 + from user_scheduler_job_run_details  
 +WHERE job_name = 'ETL_JOB'; 
  
 OUTPUT OUTPUT
Zeile 333: Zeile 339:
 <code powershell> <code powershell>
 %SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy Bypass -NoLogo -NoProfile -NonInteractive -File C:\oracle\dbScript\info.ps1 %SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy Bypass -NoLogo -NoProfile -NonInteractive -File C:\oracle\dbScript\info.ps1
 +</code>
 +
 +<code plsql>
 +BEGIN
 + DBMS_SCHEDULER.CREATE_JOB(
 +  job_name            => 'ETL_JOB2',
 +  job_type            => 'EXECUTABLE',
 +  job_action          => '%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe',
 +  number_of_arguments => 1,
 +  enabled             => FALSE,
 +  auto_drop           => TRUE,
 +  credential_name     => 'OS_USER_JOB_CONTROL2');
 + 
 + DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE('ETL_JOB2',1,'-ExecutionPolicy Bypass -NoLogo -NoProfile -NonInteractive -File C:\oracle\dbScript\info.ps1 parameter');
 + 
 + DBMS_SCHEDULER.ENABLE('ETL_JOB2');
 + 
 + END;
 +/
 +
 +
 +select ERRORS
 +   ,  OUTPUT
 + from user_scheduler_job_run_details 
 +WHERE job_name = 'ETL_JOB2';
 +
 </code> </code>
  
"Autor: Gunther Pipperr"
dba/oracle_scheduler_12c_external_scripts.txt · Zuletzt geändert: 2019/09/20 14:35 von gpipperr