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

Question

how to automate mssql queries local to dev server with jenkins? give some tutorials or document

Rajkiran Swain · Answer

To automate MSSQL queries local to a dev server with Jenkins you can use the following steps: Install the MS SQL Server Plugin for Jenkins: Go to Manage Jenkins -> Manage Plugins -> Available tab -> Search for MS SQL Server Plugin -> Install. 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. Create a Jenkins job: Go to the Jenkins dashboard -> New Item -> Enter a name for your job -> Select Freestyle project -> Click OK. 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. 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