Export (0) Print
Expand All


Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Performs maintenance of the state of operations for the SSISDB catalog.

The stored procedure fixes the status of any packages there were running if and when the SSIS server instance goes down.

You have the option of enabling the stored procedure to run automatically each time the the SSIS server instance is restarted, by selecting the Enable automatic execution of Integration Services stored procedure at SQL Server startup option in the Create Catalog dialog box.


This stored procedure requires one of the following permissions:

  • READ and MODIFY permissions on the instance of execution, READ and EXECUTE permissions on the project, and if applicable, READ permissions on the referenced environment

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft