catalog.startup
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
Applies to:
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 SSIS server instance goes down.
You have the option of enabling the stored procedure to run automatically each time 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.
Syntax
catalog.startup
Return Code Value
0 (success)
Result Sets
None
Permissions
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
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: Under hela 2024 kommer vi att fasa ut GitHub-problem som feedbackmekanism för innehåll och ersätta det med ett nytt feedbacksystem. Mer information finns i:Skicka och visa feedback för