Contains one row for each scheduled event, alert, or task that has occurred.
| Column | Datatype | Description |
|---|---|---|
| id | int | The ID of the history entry. |
| eventid | int | Reserved for future use. |
| messageid | int | The ID of the message sent. |
| severity | int | The severity of the message sent. |
| taskid | int | The ID of the task executed. |
| source | varchar(30) | The source of the event. |
| category | varchar(30) | The category of event. |
| runstatus | int | The completion type: Success, Failure, Aborted, or Skipped. |
| rundate | int | The date the event was completed. |
| runtime | int | The time of day the event was completed. |
| runduration | int | The amount of time needed to complete the task. |
| reviewstatus | varchar(32) | Reserved for future use. |
| emailoperatorid | int | The ID of the operator to whom e-mail was sent. |
| retries | int | The number of retry attempts for a task. |
| comments | varchar(255) | The description of the outcome of the task, if any. This is usually error information. |
| timesskipped | int | The number of times the task was skipped because of a server or SQL Executive problem. |
ucsyshistory clustered, unique on id
| sp_droptask | sp_helphistory | sp_purgehistory |