Has anyone tried to run Toad apps from Jenkins?
We are working on a CI solution and wanted to utilize Toad’s Schema compare options to compare and extract and schema diff script. For that we wanted to use Toad command line to run an app that would generate the diff “SQL” script.
We are using the below command to achieve it from command line:
Toad -a “appname | c:\path\schemacompare.ini”
When running the same command from jenkins Windows batch script job, it fails.
Upon investigation, it appears that when jenkins calls toad, it receives the call and briefly appears in the taskmanager and crashes immediately. The windows eventviewer logs an AppCrash event but does not have any relevant details for debugging. We have turned on the debug flag in the toad.ini file, but the jenkins call does not generate the toaddebug.txt file, while just running it at command prompt does.
Please help. We have done extensive googling of the issue and did not come across any Jenkins and Toad integration discussions anywhere.