How to save to a file

SoapUI installation also provides command line tools(%SOAPUI_HOME%/bin/testrunner.bat) to execute the SoapUI project / test suite / test case. Please check here

 

And windows scheduler task allows to run the commands. So you are good.

 

Coming to the actual problem, i think, saving the response xml of jdbc test step is easily possible with below script.

 

Add this script as Script Assertion to the JDBC Request step itself: And provide the directory for path variable in the script.

//Check if there is response
assert context.request, "Request is empty or null"

//Update the below value
def path = '/directory/path/to/store/responses'
def name_prefix = java.time.LocalDate.now().toString()

//Save the contents to a file
def saveToFile(file, content) {
    if (!file.parentFile.exists()) {
         file.parentFile.mkdirs()
         log.info "Directory did not exist, created"
    }
    file.write(content) 
    assert file.exists(), "${file.name} not created"
}

def f = new File("${path}/${name_prefix}_Response.xml")
saveToFile(f, context.response)

 

Try to execute the SoapUI project using command line and ensure response is saved before putting that into windows scheduler.

NOTE: the above script saves the response with today's date as prefix in its file name.