About this task
When you execute a Job, you can monitor the execution through the tStatCatcher Statistics option or through using a log component. This will enable you to store the collected log data in .csv files or in a database.
You can then set up the path to the log file and/or database once for good in the Project Settings dialog box so that the log data get always stored in this location.
To do so:
- On the toolbar of the Studio main window, click or click Project Settings dialog box. from the menu bar to open the
In the tree view of the dialog box, expand the Job
Settings node and then click Stats &
Logs to display the corresponding view.
If you know that the preferences for Stats & Logs will not change depending upon the context of execution, then simply set permanent preferences. If you want to apply the Stats & Logs settings individually, then it is better to set these parameters directly onto the Stats & Logs view. For more information about this view, see Automating the use of statistics & logs.
- Select the Use Statistics, Use Logs and Use Volumetrics check boxes where relevant, to select the type of log information you want to set the path for.
Select a format for the storage of the log data: select either the On Files or On
Database check box. Or select the On
Console check box to display the data in the console.
Warning: Stats or logs is not supported with JDBC generic component for Teradata. To store statistics and log data in a Teradata database, select Teradata from the Db Type drop-down list and provide related parameters for connecting the Teradata database as prompted.
The relevant fields are enabled or disabled according to these settings. Fill out the File Name between quotes or the DB name where relevant according to the type of log information you selected.
You can now store the database connection information in the Repository. Set the Property Type to Repository and browse to retrieve the relevant connection metadata. The fields get automatically completed.
Alternatively, if you save your connection information in a Context, you can also access them through Ctrl+Space.