| title | catalog.startup |
|---|---|
| description | catalog.startup |
| author | chugugrace |
| ms.author | chugu |
| ms.date | 03/04/2017 |
| ms.service | sql |
| ms.subservice | integration-services |
| ms.topic | reference |
[!INCLUDEsqlserver-ssis]
[!INCLUDE SQL Server]
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 [!INCLUDEssIS] server instance goes down.
You have the option of enabling the stored procedure to run automatically each time the [!INCLUDEssIS] 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.
catalog.startup 0 (success)
None
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