Creating an Automatic Schedule Policy for Data Protection

Applies to: Informix, Microsoft SQL Server, MongoDB, MySQL, Notes Database (traditional log backups), Oracle, Oracle RAC, PostgreSQL, SAP for Oracle, SAP HANA, Sybase, DB2, DB2 MultiNode

A data protection schedule policy is a scheduling template for data protection operations which includes both backup and archive operations.

You can add an automatic schedule to a schedule policy to run database log backups automatically. The database log backups use data protection resources efficiently by running the backup jobs only when enough data is available.

Before You Begin

You must have appropriate permissions to create a schedule policy.

Procedure

1. From the navigation pane, go to Manage > Schedules.

   The Schedules page appears.

2. Select Schedule policies tab.

3. At the top-right of the page, click Add.

   The Select Schedule Policy Type page appears.

4. Select Data Protection, and then click Next.

5. On the General page, do the following:

   1. In the Name box, enter the name of the schedule policy.

   2. From the Agent type list, select the agent for which you want to add the schedule policy, and then click Next.

6. On the Configure backup options page, do the following:

   1. From the Backup type list, select one of the following backup types: Online full, Offline full, Online incremental, Offline incremental or Log backup, and then click Next.

7. On the Configure pattern page, do the following:

   1. In the Name box, enter the policy configure pattern name.

   2. From the Frequency list, select Automatic.

   3. In the Job Interval section, specify the following:

      1. In the Back up on file activity every box, specify how often the software checks whether log files require backup and prevents jobs from running too frequently.

         Note

         • Set a low interval, such as a minimum of 15 minutes.

         • The software does not evaluate database or log threshold settings.

         • When the specified interval expires, the software evaluates log disk usage or utilization to determine whether a backup is required.

      2. In the Force a backup every box, specify how often the software performs a log backup even when threshold conditions are not met.

         Note

         • Set the interval that is less than the time interval between running two backups.

         • If no backup occurs within the specified interval, the software initiates a backup without evaluating threshold settings.

         • When the specified interval expires, the software verifies whether a backup completed within the Back up on file activity every interval using the backup finish time. Additionally, the software evaluates log disk usage or utilization to determine whether a backup is required.

      3. Select Ignore the blackout window when a backup is forced checkbox to perform forced backup even during configured blackout periods.

   4. In the Network Management section, do the following:

      1. Select Use only wired network checkbox if you want to restricts data transfer to wired network connections only.

      2. Select Min. Network Bandwidth (Kbps) checkbox to specify the minimum required network bandwidth for data transfer operations.

      3. Select Use specific network checkbox to limit data transfer to a defined IP address or subnet.

      4. Select Do not use a network configured as metered checkbox to prevents data transfer over networks marked as metered.

      5. Select Manually choose the preferred network checkbox to manually select the network for data transfer.

   5. In the Power Management section, do the following:

      1. Select Start only if the computer is running on A/C power checkbox to run the job only when the system is connected to AC power.

      2. Select Stop the task if battery mode begins checkbox to stop the running job when the system switches to battery power.

         Note

         To enable this option, you have to select Start only if the computer is running on A/C power checkbox.

      3. Select Prevent computer from going to sleep if any jobs are running checkbox to keep the system awake while jobs are in progress.

   6. In the Resource Utilization section, do the following:

      1. Select Start only if CPU utilization is below(%) checkbox to start the job only when CPU usage is below the specified percentage.

      2. Select Suspend jobs if CPU utilization is above(%) checkbox to suspend running jobs when CPU usage exceeds the specified percentage.

   7. In the Database section, do the following:

      • Oracle/Oracle RAC/SAP HANA/SQL Server/Informix/MySQL/DB2/DB2 Multinode/PostgresSQL

        1. Select the Use serverless log backups and commit every checkbox to enable Serverless log backup feature and specify the interval between each log commit operation to the CommServe server. For more information on the feature, see Serverless Log backup.

        2. Select Follow app settings for log deletion checkbox to use the application configuration to control log file deletion.

      • Oracle/Oracle RAC/SAP Oracle/Notes/MongoDB/MySQL/PostgreSQL

        1. Select Start backup when disk at log destination is checkbox to run backup jobs when the log files on the disk use the specified amount of storage space.

        2. Select the Number of Archived Logs in Log destination checkbox to run backup jobs when the log files on the disk reach a specified limit.

      • SQL/Sybase

        1. Select Start the backup when the log file is checkbox to run backup jobs when log file usage reaches the specified percentage.

8. Click Next.

9. On the Configure common options page, do the following:

   1. In the Start up options section, do the following:

      1. Select Startup in suspended state checkbox to starts the job in a suspended state until you manually resume it.

      2. Select Start when CommServe activity is low checkbox to run the job only when CommServe system activity is below a defined threshold.

      3. Move the Use default priority toggle to right to runs the job using the system-defined default priority level.

      4. If you do not move the Use default priority to right, in the Priority box, set the priority for running the jobs.

   2. In the Job retry options section, do the following:

      1. Move Enable total running time toggle to right to specify the total running time of the job.

      2. Select Kill running job when total running time expire checkbox to stop the job when it exceeds the specified maximum run time.

         Note

         To option is visible only when the Enable total running time checkbox is enabled.

      3. Move Enable number of retries toggle to right to specify the number of times the system retries a failed job.

      4. Select Queue if other conflicting jobs are active checkbox to delays the job until conflicting jobs complete.

10. Click Next.

11. On the Configure associations page, click Add.

12. On the Association dialog box, select the server or server group to associate with the schedule policy, and then click Save.

13. Click Submit.