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

Job to script all Jobs Expand / Collapse
Author
Message
Posted Saturday, October 13, 2007 9:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 04, 2005 7:31 PM
Points: 13, Visits: 1
Comments posted to this topic are about the item Job to script all Jobs


Post #410324
Posted Thursday, June 17, 2010 10:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 26, 2012 2:56 AM
Points: 1, Visits: 58
Hi,

I used this code and it worked perfect initially. But found some issues later on with the result, that its not bringing up the same result all the time.

The Problem with the results is that the Job steps are not coming in the right order... due to which the error when the resultant scripts are applied against a environment.

The specified '@step_id' is invalid (valid are: 1..1).

Are there are any specific options that mentions that the order of the Job scripts output should be based on the Step id.

Have you faced this similiar issue. if so, did you found any solution to this...
Post #939044
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse