Remove the starting and finishing triple quote marks (they’re only needed in a pipeline script)
Note you’ll need to provide the username and password as part of the command line to MySQL; you’re best to use the Credentials Binding plugin and use a ‘Username and Password (Separated)’ binding. Then you can refer to them in the batch script as regular environment variables. Regards, Daniel. From: harvey Sent: 04 September 2017 14:01 To: Jenkins Users Subject: Re: Multiple commands Hi Daniel, Thank you for your reply. I am using a freestyle job and unfortunately the script didnot work in my case: I choosed execute windows batch command and typed the following: """ cd c:\.... ....\mysql --username --password -e "DROP DATABASE xyz; CREATE DATABASE xyz;" """ Is there something which am missing ? Regards, Harvey On Monday, September 4, 2017 at 1:43:29 PM UTC+2, Daniel Butler wrote: Are you using freestyle jobs or pipeline? With Pipeline: When you use a bat/sh step you’re providing a batch or shell script rather than virtual input into a console. In your case you’d need to do something like: bat """ cd c:\... ...\mysql --user %user% --password %password% -e "DROP DATABASE xyz; CREATE DATABASE xyz;" """ Freestyle you’d use the same text between the triple quotes in a Batch step. Regards, Daniel. From: harvey Sent: 04 September 2017 12:04 To: Jenkins Users Subject: Multiple commands Hi, I am a new user to Jenkins. I just started working with Jenkins. I am learning to automate using Jenkins. But I dont find like how to pass two commands? For example, if I need to run a database creation using MySQL I should do the following: cd c:\...\MySQL 5.5 server\bin\mysql.exe password: ******** drop database xyz; create database xyz; Actually there is a wait between the execution of the commands, so how do i do it? Please if someone could help ? Regards, Harvey -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-use...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/02c8c0a5-190d-4c65-b1b5-bf29ad352759%40googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/040e2219-39ea-4490-b290-1b559eabb935%40googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/59ad5f64.48badf0a.390f2.0174%40mx.google.com. For more options, visit https://groups.google.com/d/optout.