how to automate mssql queries local to dev server with jenkins?

To automate MSSQL queries local to a dev server with Jenkins, you can use the following steps:

1. Install the MS SQL Server Plugin for Jenkins: Go to "Manage Jenkins" -> "Manage Plugins" -> "Available" tab -> Search for "MS SQL Server Plugin" -> Install.

2. Configure the MS SQL Server Plugin: Go to "Manage Jenkins" -> "Configure System" -> "MS SQL Server" section -> Add your SQL Server credentials and the name of the database you want to run queries against.

3. Create a Jenkins job: Go to the Jenkins dashboard -> "New Item" -> Enter a name for your job -> Select "Freestyle project" -> Click "OK".

4. Configure the job: Under "Source Code Management", select your version control system (e.g. Git) and enter the repository URL. Under "Build", add an "Execute Windows batch command" step and enter your SQL query.

5. Save and run the job: Click "Save" to save your job configuration and then click "Build Now" to run the job. The MS SQL Server Plugin will connect to your database, run the query, and output the results in the Jenkins console.

For more detailed instructions and examples, you can refer to the following documentation:

• MS SQL Server Plugin documentation: https://plugins.jenkins.io/ms-sql-server/
• Jenkins documentation on creating a new job: https://www.jenkins.io/doc/book/getting-started/creating-your-first-job/
• Jenkins documentation on using Windows batch commands: https://www.jenkins.io/doc/book/pipeline/syntax/#batch