Reporting: Scheduled Reports View

Document created by RSA Information Design and Development Employee on Jun 26, 2017
Version 1Show Document
  • View in full screen mode

The Scheduled Reports view allows you to create, view and manage scheduled reports. Associated procedures are provided in Schedule Reports andSet Access Control for a Report. You can:

  • Enable or disable a scheduled report.
  • Start or stop a scheduled report.
  • Edit a scheduled report.
  • Delete a scheduled report.
  • Set access permissions for a report.
  • View the execution history of a scheduled report.

To access this view:

  1. In the Security Analytics menu, click Administration Reports.

    The Manage tab is displayed.

  2. Click Reports.

    The Report view is displayed.

  3. In the Report List panel, do one of the following:

    • Click  > View Scheduled Reports.
    • Click the #Schedules column.

The following figure shows the different panels in this view:



The View Scheduled Reports has the following features:

  • Scheduled Reports toolbar
  • Scheduled Reports List panel

Scheduled Reports Toolbar

The Scheduled Reports has options to add, modify and delete the scheduled report as well as options to enable or disable the selected run configuration.

The following table lists the operations in the Scheduled Reports toolbar.

Operation    Description
add_button.png Create a new report schedule or scheduled report.
del_button.png Deletes the selected report schedule.

Edits the selected report schedule.

Note: Double-click on a desired report schedule to edit it.

schd_enable_button.png Enables the selected report schedule.
disable_icon.png Disables the selected report schedule.
schd_exec_history_icon.png View the history of the scheduled report.
filter_button.png Filter schedules based on the type of schedule. (For example, AdHoc)
other_options_icon.png Allows you to set permissions for the selected scheduled report.
autorefresh_button.png Automatically refreshes the scheduled reports list.
search_schd_button.png Searches schedules based on the schedule name.

Scheduled Reports List Panel

The Scheduled Reports List panel lists the scheduled reports in a tabular format. You can perform the following actions using the

The following table lists the columns in the Scheduled Reports List panel:

Column    Description
Name    The name of the scheduled report.
Schedule    The type of schedule for the run configuration:
  • Ad-hoc execution
  • Hourly execution
  • Daily execution
  • Weekly execution
  • Monthly execution
Last RunDisplays the last time the report was run.
Last Run(s) Displays the number of times the same report was scheduled.
Avg(s)Displays the average time taken to run the report.

Indicates the state of the scheduled report.

  • Scheduled: If a report is scheduled to run on an hourly, daily, weekly, monthly, or later time, the state of the report is displayed as scheduled, for the first run.
  • Queued: If a report is still waiting to get executed, the state of the report is displayed as queued.
  • Running: If the report schedule is in progress, the state of the report is displayed as running.
  • Partial: If in a report with several rules, a single rule execution failed or an output action failed or creation of PDF/CSV failed, the state of the report is displayed as partial. For example, consider a report with five rules and
  • four rules are executed successfully and one fails, then the state is displayed as Partial.
  • Failed: If in a report with several rules, all the rule schedule executions failed, the state of the report is displayed as failed.
  • Completed: If a report schedule is successfully executed, the state of the report is displayed as completed.
  • Canceled: When cancel request is completed, the state of the report is displayed as canceled.

Note: Cancel option may not work for Warehouse Analytics jobs. You must kill the job manually. Following are the steps to kill the job:
For MapR:
1. Get the Jobid from job logs.
2. Login to jobtracker UI and search for Jobid to kill under "Running Jobs".
Sample URL: http://<job-tracker-host>:50030/jobtracker.jsp
3. Kill the Jobid:
• Select Jobid under "Running Jobs" and click Kill Selected Jobs.
• Click on Jobid link, scroll down and click Kill this job link.
For Pivotal:
1. Get the Jobid from job logs.
2. Kill the Jobid.
For Example:
mapred job -list
mapred job -kill job_1406294496331_0385
yarn application -list
yarn application -kill application_1406294496331_0385

  • Inactive: If a report schedule is disabled, the state of the report is displayed as Inactive.
  • Not available: If the report schedule executed information is not available, the state of the report is displayed as not available.

Click to view the rule execution information and output action information. 
This pop-up notifies the status of multiple rules in a report and the time taken for its execution.

Note: You can view the rule execution and output action information for a scheduled report having the state CompletedRunningPartial or Failed. By default, the Output Actions for Completed Report on Reporting Engine Config page is set to enable, to receive an email when the report status is completed. To receive an email for Failed or Partial reports, you must disable this option.

View ReportClick to view the rule execution information on the View a Report Panel. You can view the rule execution information for a scheduled report having the state 'running' as well.
Previous Topic:Schedule Report Panel
You are here
Table of Contents > Reporting Module References > Report References > Schedule_Ref > Scheduled Reports View