Creating a task to Create Custom SQL Reports
How to create an SQL query report task to run on a distributed HCL Workload Automation environment.
About this task
Procedure
- From the navigation toolbar, click Monitoring and Reporting > Reporting > Manage Predefined Reports, and click Create.
- In the Task Information panel, from the Report type drop-down menu, select Custom SQL Report.
- In the Enter Task Information panel, define the type of scheduler engine here you want to run the task. You can select an engine at a later time. Remember that the engine name must be specified before running the task. Depending on the engine type you choose, the filtering criteria and the results you can display are different. You can also specify whether to share the task with others, to allow them to see and run the task, but not to modify it. Task and engine sharing can be disabled by the TWSWEBUIAdministrator in the global settings customizable file.
- In the Report Header panel, choose the name and the format of the output of the report and click Next to proceed or Finish to complete the task creation using all the default values. The Custom SQL Report supports only the Tables View in either HTML or CSV format.
- In the Filter Criteria panel, enter the SQL statement on which you want to base your report. You can write the query in the text pane or load an existing query from a file by browsing to the required file and clicking Load. Click Next to proceed or Finish to complete the task creation using all the default values.
- In the Report Output Content panel, select the job information that you want to display in the report output. After you make your selection click Next to proceed or Finish to complete the task creation using all the default values.