Job:
[SSIS Server Maintenance Job]
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 |
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) |
Name | Creation Date |
SSISDB Scheduler | 28.07.2016 |
Name | Type | |
1 | SSIS Server Operation Records Maintenance | TSQL |
2 | SSIS Server Max Version Per Project Maintenance | TSQL |