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

all – truncates all job history records.

job_name – the name of the job for which to truncate history.

history_id – a 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 June 6, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com