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

  • This was a good piece of information. I actually thought about adding the "USE" statement, but I thought that controlled where the SP would be created. Your statement leads me to believe the stored procedure would still be created on the Master but when executed would run over the "USE" database. I'm displaying my lack of basic T-SQL knowledge.

    I'll use that approach instead of copying the script into a job step. I could see that getting missed if we ever modify the SP.

    Again, many thanks. You've been a great help.