Set up and maintain the system transaction log

You can set up and maintain system transaction log in the Transaction log form. The transaction log is saved in the database and can be displayed and reviews using SQL statements.

You can also use the View job queue and View management log buttons located at the bottom of the Transaction log form to display and review the job queue and management logs respectively.

Open the Transaction log form

The Transaction log form is opened from the ScanSQL form > SJBase > Subscriptions.

Enable and set up transaction logging

1. In the Transaction log form:
2. In the Transaction log field group, select On to enable transaction logging
3. Click Save to save the setting.
4. In the Transaction log period to be keept field group > Whole months to be keept field, select the number months the transaction log is to be retained.  You can only enter a value between 1 and 12 months.
5. Click Save to save the retention period of the transaction log.

See also

The ScanSQL form