Job: [SSIS Server Maintenance Job]

CollapseAll image

Collapse image 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

Collapse image 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)

Collapse image Schedules


 Name   Creation Date 
SSISDB Scheduler 28.07.2016

Collapse image Steps


   Name   Type 
1 SSIS Server Operation Records Maintenance TSQL
2 SSIS Server Max Version Per Project Maintenance TSQL

Collapse image See also


Jobs