Job:
[SSIS Server Maintenance Job]
Job properties
| Name | Value |
| Name | [SSIS Server Maintenance Job] |
| Description | Runs every day. The job removes operation records from the database that are outside the retention window and maintains a maximum number of versions per project. |
| Category | [Uncategorized (Local)] |
| Type | Local job |
| Owner | ##MS_SSISServerCleanupJobLogin## |
| Enabled | ![]() |
| Version number | 3 |
| Creation date | 28.07.2016 |
| Last modified date | 28.07.2016 |
| Last run date | 25.10.2016 |
| Last run status | Succeeded |
| Originating server | ALEN-PC\SQLSERVER2016 |
| Has schedule | ![]() |
| ID | 3aff5278-fb7d-4381-9eaa-2e6088a29c8f |
| Start step ID | 1 |
Notification properties
| Name | Value |
| Delete on completion | Default. Ignore any completion status. Do not delete |
| E-mail notification on completion | Ignore any completion status. Do not send e-mail when the job completes |
| Log entry on completion | Log failed job completion |
| Network message notification on completion | Ignore any completion status. Do not send network message to operator |
| Page notification on completion | Ignore any completion status. Do not page operator |
| Operator receiving e-mail notification | (unknown) |
| Operator receiving net send notification | (unknown) |
| Operator receiving page notification | (unknown) |
Schedules
| Name | Creation Date |
| SSISDB Scheduler | 28.07.2016 |
Steps
| Name | Type | |
| 1 | SSIS Server Operation Records Maintenance | TSQL |
| 2 | SSIS Server Max Version Per Project Maintenance | TSQL |
See also