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

Smart way to script sql servers jobs Expand / Collapse
Author
Message
Posted Wednesday, November 20, 2013 4:15 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:01 AM
Points: 1,299, Visits: 3,003

I am wondering if someone has a free ware tool which can connect to given server and script ONLY set of jobs. I am thinking of a config file which will have the servername and job name, the tool should connect to each of those servers and script out the jobs .
Post #1516254
Posted Thursday, November 21, 2013 8:45 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 10:54 AM
Points: 299, Visits: 1,904
Hi,

If you have used powershell before, look at http://gallery.technet.microsoft.com/scriptcenter/9d0070f5-98d3-4c82-9b20-555c49f6537d
Post #1516461
Posted Friday, November 22, 2013 11:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:01 AM
Points: 1,299, Visits: 3,003
clayman (11/21/2013)
Hi,

If you have used powershell before, look at http://gallery.technet.microsoft.com/scriptcenter/9d0070f5-98d3-4c82-9b20-555c49f6537d


I just want to script out given jobs, basically i am thinking of having a config file which will have a server name and job name, PS script should be able to connect to the server based from the config file and just scipt the job name in the config file..
Post #1516884
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse