LogoLogo
  • Welcome
  • Overview
    • Architecture
      • API Server
      • Sizing
    • Dashboard Overview
    • Monitoring Concepts
      • Application Performance Management
        • Availability Monitoring
        • Performance Intelligence
        • Service Level Management
        • Synthetic Transaction Management
        • Alerts Management
        • Reporting & Analytics
      • Infrastructure Monitoring
      • Unified Monitoring
    • Automation Concepts
      • Definition of Terms
      • Infrastructure as Code
        • Project Structure and Organization
        • Setting Up IaC Environment
        • Infrastructure Provisioning
        • Configuration Management
      • SAP Basis Automation
      • Automated Migration
  • User Guide
    • Onboarding
    • Setup
      • Gateway Setup
        • Gateway Network Setup
        • IT-Conductor Gateway Setup on Windows
        • IT-Conductor Gateway Setup on Linux
        • IT-Conductor Gateway Setup on AWS
        • IT-Conductor Gateway Setup on Azure
        • IT-Conductor Gateway Setup for SAP Secure Network Communications (SNC)
      • API Server Setup
      • MSP Tenant Setup
      • SSO Setup
        • Azure ADFS Identity Provider
        • Azure Active Directory (AAD) App Gallery
    • Monitoring
      • General
        • Maintenance Mode
          • Manual Maintenance
          • Scheduled Maintenance
        • Central Syslog Server Monitoring
        • URL Monitoring Locations
      • Cloud Monitoring
        • AWS Monitoring
        • Microsoft Azure Monitoring
      • Database Monitoring
        • IBM DB2 Database Monitoring
        • Microsoft SQL Server Monitoring
        • Oracle Database Monitoring
        • SAP HANA System Monitoring
          • SAP HANA Scale-Out Monitoring
          • SAP HANA Overview Dashboard
          • SAP HANA Alert Management
        • SAP ASE Database Monitoring
        • SAP MaxDB Monitoring
        • HA/DR Monitoring
      • Infrastructure Monitoring
        • File Server Monitoring
          • File Watcher Monitoring
        • Git Server
        • OS Monitoring
          • Unix/Linux System Monitoring
            • Linux Network Interface Monitoring
            • OS Printer Monitoring
          • Windows System Monitoring
            • WinRM Adapter Configuration
              • WinRM Services Configuration
              • Domain User Access
              • WMI Namespace Access
              • Windows Service Configuration
        • VMWare vCenter Monitoring
      • SAP Monitoring
        • Business Process Monitoring
          • Business Process Composer
          • BDoc Monitoring
          • IDoc Monitoring
        • SAP BusinessObjects Monitoring
          • SAP BO Data Services Monitoring
        • SAP Cloud Connector Monitoring
        • SAP Host Agent Monitoring
        • SAP NetWeaver Monitoring
          • SAP ABAP System Monitoring
            • SAP Transports
            • Security Role Import
            • SAP ABAP Overview Dashboard
            • SAP CCMS Alert Monitoring
            • SAP Batch Jobs Monitoring
              • SAP Batch Job Monitoring for CCMS Alerts
              • Advanced SAP Batch Job Monitoring
            • SAP SLT & RFC Connection Monitoring
            • Print Spooler Monitoring
            • Workload Monitoring
              • Transaction Code Monitoring
              • SAP Workload Monitoring
          • SAP J2EE System Monitoring
            • SAP J2EE Monitoring Role
            • Keystore Views and Certificates Monitoring
            • SAP PO Application Monitoring
          • SAP Systems Administrator Panel
        • SAP Web Dispatcher Monitoring
        • LMDB Discovery
        • Team-Based Central SAP Download Manager
    • Automation
      • Migration
        • Oracle to AWS Migration
        • Oracle to ASE Migration
        • SAP on MSSQL to AWS Migration
        • S/4HANA to Cloud Migration
      • E2E System Refresh Automation
        • Frequently Asked Questions
      • Age-based HANA Backup Automation
      • Inbound/Outbound Queue Restart Automation
      • OS File System Cleanup Automation
      • OS Linux Pacemaker Cluster Error Management
      • OS Printer Queue Restart Automation
      • OS Linux Kernel Patching using ChAI
      • OS Linux System Reboot using ChAI
      • SAP Batch Job Restart on Error
      • SAP Kernel Update using ChAI
      • SAP HANA Account Activation using ChAI
      • SAP Transports using ChAI
        • Frequently Asked Questions
      • SAP User Unlock and Password Reset Automation
      • Start/Stop Automation
    • Reporting
      • Available Reports
      • Creating Reports
        • Service Health KPI Report
      • Scheduling Reports
        • Automated HANA Reports
      • Report Elements
      • Archived Alerts Reporting
    • Account Administration
      • Invite Users
      • Create Robot Users
      • Update Linux System Account Password After Expiration
    • Notifications
      • Alerts
      • Threshold Overrides
        • Threshold Overrides Variables
      • Notification Targets
      • Distribution Lists
      • Subscriptions
      • Custom SMTP Notification Providers
      • Integration Providers
        • Derdack EA Integration
        • ilert Integration
        • Jira Service Desk Integration
        • Microsoft Teams Integration
        • PagerDuty Integration
        • Slack Integration
      • On-Call Scheduling
      • Calendar Events
    • Diagnostics
      • Gateway Communication Dump Debug Mode
      • Running IT-Conductor Gateway from CLI
      • SAP CCMS Missing Data
    • IT-Conductor FLUX
    • SID-Refresh
      • Product Overview
      • Getting Started
      • Documentation
      • Release Notes
      • Frequently Asked Questions
      • Troubleshooting Guide
        • Component CRM_MIDDLEWA_CRM - CRM Middleware Configuration
        • Failure to Start the Java-based GUI
        • Inconsistencies found in the table TADIR
        • Java-based GUI Runs with Pixelated Fonts
        • No email message is created after sending an email in SO01
        • Program Run as root
        • SICF Wrong Credentials
        • SU01: Error in user management
        • External Resources
      • Pricing
  • Release Notes
    • Gateway
  • References
    • Open-Source Software
    • Support
Powered by GitBook
On this page
  • Pre-requisites
  • How to Schedule a HANA Report on IT-Conductor?
  • Related Information
  1. User Guide
  2. Reporting
  3. Scheduling Reports

Automated HANA Reports

PreviousScheduling ReportsNextReport Elements

Last updated 17 days ago

This wiki documentation provides a step-by-step guide for scheduling and automating HANA SQL reports within IT-Conductor. It outlines the process for creating schedules, defining report templates, and assigning schedules to ensure that HANA reports run at specified times.

Pre-requisites

Before scheduling any reports, please make sure you've completed the following tasks below.

  • Configure your HANA Systems for monitoring in IT-Conductor. See for more details

How to Schedule a HANA Report on IT-Conductor?

Create a Schedule

  1. Visit and enter your login credentials.

  2. In the main menu, navigate to Management → Automation → Schedules.

  3. On the Schedules screen, click the button to create a new item.

  1. Fill out all the necessary information in the Create Process Schedule screen.

    1. Name - refers to the schedule name.

    2. Description - Enter a description for the schedule.

    3. Organization: refers to an administrative structure that defines objects with a common goal or purpose. If you previously created an organization, please select it.

    4. Work Days - refers to the specific days of the week on which the schedule is active.

    5. Observe Holidays - if checked, it indicates whether the schedule should skip execution on defined holidays.

    6. Instance Removal Age - defines how long completed report instances are retained before automatic deletion.

    7. Instance Owner - refers to the owner of the report instance when it is generated at the scheduled time.

    8. Context Mode - determines the method for applying context. The options are Single, Object Group, and Enumerate. In most cases, select Single; this will activate the following two options.

    9. Context Class - refers to the system or environment type relevant to the report (e.g., SAP system, HANA System, Windows System, etc.). For this purpose, we’ll select the HANA System.

    10. Context Object - select the system where the report will be scheduled to run

Create a Report Definition for the HANA system

  1. On the main grid, navigate to the HANA system that you selected in the previous step and click on SQL Jobs.

    1. Name - refers to the name of the HANA SQL report.

    2. Description - refers to the description of the report.

    3. Database - refers to the target database where the SQL query will be executed. This will be substituted when the report is instantiated.

    4. Schedule - don’t assign the schedule yet.

    5. Planned Start Time - defines the intended time of day the report is set to begin execution (Optional if you’re already assigning a schedule to the report).

    6. Time Windows Begin - defines the start of the allowed time range for report execution (Optional if you’re already assigning a schedule to the report).

    7. Time Windows End - defines the end of the allowed time range for report execution (Optional if you’re already assigning a schedule to the report).

    8. Repeat - this option is not applicable in this scenario.

    9. Complete Monitoring - this enables the triggering of a recovery action using thresholds.

    10. Deliver Log - if checked, it sends execution logs to designated recipients.

      1. Deliver On - specifies the conditions under which the log should be sent. The options are: Any, Failure, and Success.

      2. Deliver Log To - refers to the primary recipient of the report execution log.

      3. Deliver CC - refers to an optional secondary email address to receive a copy of the log.

      4. Deliver Log As - defines how the log is delivered—either as an email attachment or inline in the message body.

      5. Delivery Message - refers to the subject line or message included in the log delivery email.

    11. SQL - refers to the core query logic written in SQL that retrieves report data.

    12. Echo - if checked, the option will print the SQL statement in the report output.

    13. Output Type - refers to the format of the report output (e.g., CSV, HTML, TEXT).

    14. Preserve Formatting - if checked, it maintains original layout/structure in the output file.

    15. Wrapped - if checked, it controls whether long lines in the output are wrapped or truncated.

    16. Query Timeout - refers to the maximum execution time allowed for the SQL query before it’s terminated. By default, it’s set to 180 seconds.

Related Information

Time Windows: Specific time ranges during which the schedule will be active. To add a time window, click on the Add New Row button and select a time to start and end.

Formulae - refers to the frequency of the scheduling (e.g., daily, monthly). To add a frequency, click on the Add New Row button. This option allows you to be very specific about the frequency of the scheduling. You may specify the frequency by position (e.g., first day of the month, last day of the month, etc), day of the week, week (e.g., first week of the month, second week of the month, etc), month, or quarter.

Once it’s completed, click on the button to save.

You may choose to create a report from a template by clicking on the Templates button or from zero by clicking on the button. In this case, we’ll create a new report template.

To create a new template, click on the button and fill out all the necessary information in the New SQL Script Template screen.

Click on the button to save, and you will be returned to the SQL Script Templates screen.

To assign a schedule to your new SQL report template, click the Schedule icon in the Tools column.

Check the schedule you wish to add and click on the Save button.

Scheduling Reports
SAP HANA System Monitoring
service.itconductor.com
Figure 1: List of Schedules in IT-Conductor
Figure 2a: Create a New Schedule
Figure 2b: Create a New Schedule
Figure 3: SQL Jobs in HANA System
Figure 4: List of Existing SQL Jobs
Figure 5a: Create new SQL Template
Figure 5b: Create new SQL Template
Figure 6: List of SQL Templates in IT-Conductor
Figure 7: Assign a Schedule to a Report