NetBackup IT Analytics 系统管理指南

自动化 NetBackup 实用程序

可以将本部分中列出的 Cohesity NetBackup 实用程序设置为自动运行。可以对存储过程进行编辑，以自定义要在特定计划中作为后台作业运行的实用程序列表。

Windows：C:\opt\oracle\database\stored_procedures\nbu\setup_nbu_jobs_manual.sql

Linux：opt/aptare/database/stored_procedures/nbu/setup_nbu_jobs_manual.sql

所有五个实用程序都包含在此文件中。要从计划作业中忽略特定的实用程序，请在代码块前后使用以下语法。

请参见Veritas NetBackup 实用程序。

在文本编辑器中，打开 setup_nbu_jobs_manual.sql 文件并根据需要修改计划。以下示例说明了如何编辑语法以自定义计划。

----------------------------------------------------------------------------------------
    -- Move clients that are in inactive policies
    -- Frequency: Every day at 02:30
    ----------------------------------------------------------------------------------------
    jobName := dba_package.getSchedulerJobName('setupInactivePolicyClients');
   
    IF (jobName IS NOT NULL AND LOWER(jobName) <> LOWER('setupInactivePolicyClients')) THEN
        DBMS_OUTPUT.PUT_LINE('setupInactivePolicyClients 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         => 'setupInactivePolicyClients', 
            job_type         => 'PLSQL_BLOCK',
            job_action       => 'server_mgmt_pkg.setupInactivePolicyClients(NULL, NULL, 0, 0);',  -- What to run
            start_date       => SYSDATE + (5/48),           -- First run is 150 mins from initial installation
            repeat_interval  => 'TRUNC(SYSDATE+1,''DD'') + (5/48)',  -- Next run is 2:30 each subsequent day
            enabled          => TRUE); 
    ELSE
       DBMS_OUTPUT.PUT_LINE('setupInactivePolicyClients 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        =>  'server_mgmt_pkg.setupInactivePolicyClients(NULL, NULL, 0, 0);'
            );  
       DBMS_SCHEDULER.SET_ATTRIBUTE(
            name         => jobName,
            attribute    => 'repeat_interval',
            value        => 'TRUNC(SYSDATE+1,''DD'') + (5/48)'
            );     
    END IF;                       
    DBMS_OUTPUT.put_line('setupInactivePolicyClients set to run at 2:30 every day');