indianyogi
Active Member
All
We designed an interface(Table Coversion) to export jdedwards invoice information to Oracle Financials. There was need to call an Oracle Stored Procedure, which we implemented by calling a batch file which ran the SQL File. Now, we are trying to schedule the job on the server, and I am not sure, how to take care of the batch file thing. I am kind of getting lost as how to call a sql procedure after execution of a TC submitted on the server.
Thanks
Yogi
We designed an interface(Table Coversion) to export jdedwards invoice information to Oracle Financials. There was need to call an Oracle Stored Procedure, which we implemented by calling a batch file which ran the SQL File. Now, we are trying to schedule the job on the server, and I am not sure, how to take care of the batch file thing. I am kind of getting lost as how to call a sql procedure after execution of a TC submitted on the server.
Thanks
Yogi