Creating a report bursting schedule

You can create report schedules to download reports at specific intervals. This topic provides instructions on creating a report burst schedule.

Creating a schedule on Windows

Do the following:

1. From <link>, copy the ReportsBurstUtility.jar file.
2. Paste it in the <install_directory>/utilities/ folder.

3. Create a support report that contains a single column that lists all values of the filter. The single column is the burst filter.

   Warning

   Important

   • Create a separate support report for each burst filter.
   • To filter values of the support report data, add the required columns to the report as a filter with defined values.

4. Configure the report_burst.properties file for every report user.

   Warning

   Important

   • The file can contain configurations for multiple reports on which you want to perform bursting.
   • Each burst schedule needs a separate properties file. You can create a properties file separately for each burst schedule and save the file with any name.
5. Run the Reports Burst utility from the Windows Task Scheduler. Do the following;

   1. Run the <install_directory>/utilities/run.bat file. Ensure that you add the correct paths for the Java executable, the Report Burst utility directory, and the report burst configuration properties file.
      
      

      The run.bat file

      @echo off

      cd <report burst utility path>

      <"absolute java path till java.exe file"> -jar ReportBurstUtility.jar <"absolute path of configuration file">

      Example

      @echo off

      cd <C:\Program Files\BMC Software\TrueSightSmartReporting\utilities\ReportBurstUtility>

      "<C:\Program Files\BMC Software\TSSA-DW\jre\bin\java.exe>" -jar ReportBurstUtility.jar "<C:\Program Files\BMC Software\TrueSightSmartReporting\utilities\ReportBurstUtility\report_burst.properties>
   2. In the Windows Task Scheduler, create a task.
   3. Configure a schedule for the report burst.
   4. On the Actions tab, provide the location of the run.bat file and click OK.

Creating a schedule on Linux

Do the following:

1. From <link>, copy the ReportsBurstUtility.jar file.
2. Paste it in the <install_directory>/utilities/ folder. (Need folder details on Linux)

3. Update the run.sh file to provide the execute permission to the run.sh and ReportBurstUtility.jar files. Use the following syntax:
   
   

   Syntax

    #!/bin/bash

          cd <report burst utility path>

          java -jar ReportBurstUtility.jar <"absolute path of configuration file">

   Example

    #!/bin/bash

          cd /data1/TrueSightSmartReporting/utilities/ReportBurstUtility

          java -jar ReportBurstUtility.jar "/data1/TrueSightSmartReporting/utilities/ReportBurstUtility/report_burst.properties"
4. Open the crontrab by using the following command:
   crontab -e (does this command start with capital C?)

5. Add the execution command and save the file. Use the following syntax.

   Syntax

    <Cron schedule trigger configuration> <command>

   Example

    0 2 * * * /data1/TrueSightSmartReporting/utilities/ReportBurstUtility/run.sh

   In this example, the cron job is executed at 2 AM every day.

6. (Optional) Check the list of scheduled cron jobs. Use the following commands:
   crontab -l (does this command start with capital C?)