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.
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.
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers