Have you looked into using a matrix build to run a build job on all of the slave nodes at the same time? Just put the script in a common location and reference it via unc path in your build steps. Then set the matrix job to run on each of the nodes and then run the job, should be pretty easy, especially if the script name is set the same each time. If it's a different name each time, you could just set the build to need a parameter and when you run the build Jenkins should prompt you for a parameter value that you can use to point to the script.
This is assuming that your sql script can be run as the same user that Jenkins is running as on your slave nodes, as that's the user that will be running the build job. Scott On Tue, Oct 15, 2013 at 12:10 PM, Maneesh M P <[email protected]>wrote: > our developers gives a mysql script file [abc.sql] each time to execute on > all the build servers [we have 7 slave nodes]. So every time I have to > manually login and execute the sql command in all build servers. > Is there a way from jenkins I can browse and select the sql file as input > parameter and execute over ssh in all the build servers? > > Thanks > M > > -- > 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 [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
