About this task
Use this task to define your own reports by writing or importing
SQL queries for extracting data in HTML or CSV format. To create an
SQL report task, perform the following steps:
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.
- In the Create New Task panel:
- Select Run this Task Now and click Finish if
you want to run the report task. If you have not yet specified an
engine connection, you are prompted to do so now.
- Click Cancel to exit without saving your changes.
- Click Finish to save the task, without starting it
immediately.
Results
You have created your task that, when run, creates a report
satisfying your filtering criteria and showing the information you
selected to view.