Home Forums SQL Server 2005 Administering Create and then execute a stored procedure in a job step RE: Create and then execute a stored procedure in a job step
Sergey Vavinskiy
SSCarpal Tunnel
Points: 4469
More actions
September 25, 2009 at 9:19 am
#1058521
You are welcome.
Just remember that code of SP doesn't care about physical location of SP, only a job does. So if you put the USE YourDB_name... statement in a code of SP, the code will be running against YourDB_name database.