Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
HarrisSQL
Starting Member
2 Posts |
 Posted - 2011-02-08 : 10:55:18
|
| Im fairly new to SQL. Im using SQL Server 2008 Dev Edition. My question is, the company i work for has 10 standard maint jobs that has to be set up on each server. Is there a way in which i can set something up to load all ten plans and their parameters in one shot. Kind of like a standard package for setting up new servers. Doing this would save clock hours using the gui. Also in my section alone there are 650+ servers needing this standard applied. Some GUI interface is okay but the less we use it the better in this instanceShaun Harris |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-08 : 13:37:04
|
| I have several scripts I keep handy to apply everytime we setup a new server.Yours will depend on what you want to standardize. |
 |
|
|
|
|
|
Standard Maintenace Plan Without Using GUI