Routine to Connect the DataBase

pklcnu · Post by **pklcnu** » 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

miwinter · Post by **miwinter** » Tue Aug 04, 2009 8:57 am

Call an update script in an after job routine that only runs on job success.

pklcnu · Post by **pklcnu** » Tue Aug 04, 2009 9:05 am

miwinter wrote:Call an update script in an after job routine that only runs on job success.

Thanks for the reply......my question was what lines of code that i need to include in the routine in order to connect to the Database......like DBName, UserName, Password etc.........how to write this in the routine apart from the update script.

Thanks

priyadarshikunal · Post by **priyadarshikunal** » Tue Aug 04, 2009 9:17 am

This has been answered before. Probably you can search for "SQLConnect".

chulett · Post by **chulett** » Tue Aug 04, 2009 10:23 am

You don't need a routine and that would just complicate this. Leverage the command line interface for your DB from a script - for example, using sqlplus for Oracle. So for SQL Server it would be isql I believe, yes?