For Oracle try entering your command as a single Pl/SQL block like BEGIN delete from "table1" where "column1" like 'jblow'; delete from "table2" where "column1" like 'jblow'; END : When entering new jobs via the job wizard, and I get to the SQL Command(s) : box, : I get errors if I enter more than 1 command, for example; : delete from "table1" where "column1" like 'jblow' : delete from "table2" where "column1" like 'jblow' : If I add ";" to the end of each command I get ora-00911 : "invalid character" : If I remove the ";" from the end of each command I get ora-00933 : "command not properly ended" : any ideas?? there are no debugging tools for sql that I see in this (24x7)
|