Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction

Create SQL Server plugin procedures

1 minute readExtensibilityDeveloper productivity
On this page

Plugin procedures can be used in procedure steps, process steps, and pipeline tasks, allowing you to orchestrate third-party tools at the appropriate time in your component, application process, or pipeline.

Depending on your plugin configuration and how you run procedures, the Input parameters  Configuration name field may behave differently in the CloudBees CD/RO UI. For more information, refer to Differences in plugin UI behavior.

RunSQLFile

Execute a SQL file in SQL Server

Input parameters

Table 1. RunSQLFile input parameters
Parameter Description

Configuration name

Required. The previously defined configuration for the plugin.

Path to sqlcmd (DEPRECATED)

Absolute path to the SQL Server utility sqlcmd. Overrides the CLI path defined in the plugin’s configuration.

Server

Required. The name of the server you want to connect to.

SQL Statement

Provide any SQL statement to run against the database.

Database name

Issues a USE db_name statement when sqlcmd is started.

Path to a SQL file

Absolute path to your SQL file.

Result (output property path)

Property name used to store the result of queries.
Create SQL Server plugin configurations
SQL Server plugin release notes