Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Agent Job task Expand / Collapse
Author
Message
Posted Monday, September 16, 2013 3:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 11:49 AM
Points: 7, Visits: 177
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.
Post #1495291
Posted Monday, September 16, 2013 3:09 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:33 AM
Points: 153, Visits: 977
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
Post #1495295
Posted Monday, September 16, 2013 7:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 11:49 AM
Points: 7, Visits: 177


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..

Post #1495349
Posted Tuesday, September 17, 2013 11:09 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:33 AM
Points: 153, Visits: 977
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
Post #1495597
Posted Thursday, October 10, 2013 12:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 6:57 AM
Points: 21, Visits: 306
Try running job under 'sa' account .
Post #1503744
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse