INTRODUCTION

The Runtime Audit Browser provides a web-based interface to the ETL job runs. Sceenshots to accompany this documnetation can be viewed at http://trac.assembla.com/etlp/wiki/UsingTheAuditBrowser

SETTING UP USERS

When ETLp is first installed, it creates a single account admin with the password of admin. The first thing the administrator should do is login and change the admin password, and create a new user.

The login URL will typically be !http://<!MyHost>/etlp/user/login. Check with your system administrator if this is not the case in your environment.

Changing the Admin Password

1. Click on the Edit Password menu option.
2. Enter the existing password and the new password twice.
3. Save the changes.

Create a New User

1. Select the User Admin menu option.
2. Click on the New User button.
3. Fill in the user's details.
  • If the Active checkbox is not selected, the user will not be able to log in.

  • The Administrator option determines whether the user has administration privileges. This allows the user to create new users and edit user details

JOBS

The Jobs option allows you browse jobs that have run. The filter bar allows you to search jobs based on specific criteria

  • Config refers to the configuration file.

  • Section is the section within the configuration file. Together, the configuration file and the section uniquely define a job.

  • Status refers to the state of the job:

    • failed: The job dies.

    • reaped: The job died unexpectedly when running (e.g. it was killed from the operating system). This is not currently implemented.

    • running: The job is currently running.

    • succeeded: The job ran to completion successfully.

    • warning: One of the job's items failed, but the job continued to run. This will occur if the failed item's on_error status is skip or ignore

  • Min start date: specifies the minimum date when the job started.

  • Max startdate specifies the maximum date when the job started.

ITEMS

A job's items can be views by clicking on the items link on the job page. All items can be viewed - regardless of the job - by clicking on Items in the menu

The message column records any messages generated during the item execution

When accessing the items report via a job, the items can be filtered by name or status. If the report is accessed from the ''Items'' menu, jobs can be filtered on status.

FILES

You can view information by an individual item's file processing by clicking on the filename. Alternativelt, you can view all files from the Files menu option.

Clicking on a filename will show all processing of that file, even if the file has been renamed during its lifetime.