September 16, 2013 at 3:00 pm
Hey All,
I have been tasked to copy a sql agent job from prod instance to dev instance but I keep receiving errors. Secondly, the job in question has 35 steps. The end goal is to break the job into smaller jobs with smaller steps to help prevent failures when the job is ran overnight. Any idea how to tackle this? Any feedback is greatly appreciated.
September 16, 2013 at 3:09 pm
You may want to share the errors that you are getting.
You have to fix them one by one, unless one builds upon the other.. which nobody can tell from this description.
Generally it should work like that.
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
September 16, 2013 at 7:49 pm
Thanks for your response, Andreas. Here is the error I am getting...
Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 243
The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator).
when i changed the operator name to Null, I received this error...
Warning: Non-existent step referenced by @on_success_step_id.
Msg 14262, Level 16, State 1, Procedure sp_verify_jobstep, Line 279
The specified @database_name ('NorthStar') does not exist.
NorthStar is a database that exists on the prod instance. So that error is not correct..
September 17, 2013 at 11:09 am
Ok. I you say both is there, it might be so. But then why should the error come up.
Other than that it might be a case-sensitive instance, I have no idea right now. I'm sure you'll fix it, but I can't think of a question that leads further right now..
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
October 10, 2013 at 12:43 pm
Try running job under 'sa' account .
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply