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 Reporting > Create Custom SQL Reports, and click New.
- In the Create Task panel, select Report Definition > Custom SQL Report Task > Next.
- 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.