Routine to Connect the DataBase
Posted: Tue Aug 04, 2009 8:55 am
Dear Experts
I need to run an update script after the job execution. I tried using Stored Procedure stage but it don't have option for SQL server. Is there any way either to call a Stored Procedure from routine or writing the script in routine and then call the Database through routine ?
If so can you please explain how to call the Database through routine.
Many Thanks
I need to run an update script after the job execution. I tried using Stored Procedure stage but it don't have option for SQL server. Is there any way either to call a Stored Procedure from routine or writing the script in routine and then call the Database through routine ?
If so can you please explain how to call the Database through routine.
Many Thanks