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