truncate history

Deletes existing job history records or the history records belonging to a single job, including reports and reconciliation scripts.

Syntax

truncate history all |(job_name ALL|history_id)

Parameters

job_name – the name of the job for which to truncate history.
all – truncates all job history records.
historyid – the job history sequence ID.

Examples

Example 1 – deletes the history records for all jobs:
```
truncate history all
go
```
Example 2 – deletes the history records up to and including the particular job history ID:
```
truncate history job_name 1
go
```

Parent topic: Managing Job Commands

Created December 15, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com