How to execute sql queries through jenkins?

[sravani K]

Hello,

I am new to Jenkins. I am trying to execute sql queries through Jenkins, can you please share any videos with me which will be helpful to do this job. I also want to let you know that I don't have much experience. Any videos for beginners level would be helpful.

Thank you!

[Victor Martinez]

Likely you can start with: https://jenkins.io/doc/pipeline/tour/getting-started/

Then you can code your script to run the sql queries by command line and use the shell step if you use freestylejobs or sh step if you use pipelines. Although, you might require to ensure the configuration and software dependencies are in place either in the agent side or using docker.

My two cents,

Cheers