NetBackup IT Analytics 시스템 관리자 설명서

포털 서버에서 데이터베이스 프로시저 디렉터리로 이동하십시오.

Windows: C:\opt\oracle\database\stored_procedures\srm

Linux: /opt/aptare/database/stored_procedures/srm

setup_srm_jobs.plb 스크립트를 편집하십시오.

빨간색으로 표시된 매개 변수를 확인하고 적절히 수정하십시오.

jobName := dba_package.getSchedulerJobName('recalIntPerformanceProfile');
    
    IF (jobName IS NOT NULL AND LOWER(jobName) <> LOWER('recalIntPerformanceProfile')) 
THEN
        DBMS_OUTPUT.PUT_LINE('recalIntPerformanceProfile exists with default name 
'|| jobName ||' hence will be removed and recreated.');
        DBMS_SCHEDULER.DROP_JOB(job_name => jobName);
        jobName := NULL;
    END IF;
    
    IF jobName IS NULL THEN    
        DBMS_SCHEDULER.CREATE_JOB(
            job_name         => 'recalIntPerformanceProfile', 
            job_type         => 'PLSQL_BLOCK',
            job_action       => 'srm_array_perf_report_pkg.recalIntPerformanceProfile
(dateRangeType(null,null,null,SYSDATE-2/24, SYSDATE, null, 0));',  -- What to run
            start_date       => SYSDATE + (3/24),                           
-- First run is 3 hour after upgrade or install
            repeat_interval  => 'TRUNC(SYSDATE+1,''DD'') + (10/24)',       
-- Next run is 10am each subsequent day
            enabled          => TRUE); 
    ELSE
       DBMS_OUTPUT.PUT_LINE('recalIntPerformanceProfile exists and will be altered 
with updated version.');
       DBMS_SCHEDULER.SET_ATTRIBUTE(
            name         => jobName,
            attribute    => 'job_type',
            value        => 'PLSQL_BLOCK'
            );
       DBMS_SCHEDULER.SET_ATTRIBUTE(
            name         => jobName,
            attribute    => 'job_action',
            value        => 'srm_array_perf_report_pkg.recalIntPerformanceProfile
(dateRangeType(null,null,null,SYSDATE-2/24, SYSDATE, null, 0));'  -- What to run
            );  
       DBMS_SCHEDULER.SET_ATTRIBUTE(
            name         => jobName,
            attribute    => 'repeat_interval',
            value        => 'TRUNC(SYSDATE+1,''DD'') + (10/24)'       
-- Next run is 10am each subsequent day
            );     
    END IF;       
            
    DBMS_OUTPUT.put_line('recalIntPerformanceProfile set to run on daily at 10am');      

다음 명령을 실행하여 새 예약을 활성화하십시오.

su - aptare
sqlplus portal/portal@//localhost:1521/scdb @setup_srm_jobs.plb