Could not find stored procedure 'sp_stop_job'.Turns out I had made the call to sp_stop_job in the current connection that was pointing to the logging database.
Just had to modify the call to look like "msdb.dbo.sp_stop_job"
Monday, August 23, 2010
Could not find stored procedure 'sp_stop_job'
Deployed my SSIS package to QA and the job threw an error
Just had to modify the call to look like "msdb.dbo.sp_stop_job"
Just had to modify the call to look like "msdb.dbo.sp_stop_job"
Subscribe to:
Post Comments (Atom)
1 comment:
Thank you!
Post a Comment