I was wondering if it is possible to create some sort of script to auto generate SQL maintenance plans.
We use the same plans across all SQL servers and would like to save time when installing new instances by simply running a script to create the plans instead of doing it from scratch every time.
Can this be done either in SQL itself or ideally via a PowerShell script, my Google-fu is weak today and I cant find anything that suggests this can be done.
Thanks.
We use the same plans across all SQL servers and would like to save time when installing new instances by simply running a script to create the plans instead of doing it from scratch every time.
Can this be done either in SQL itself or ideally via a PowerShell script, my Google-fu is weak today and I cant find anything that suggests this can be done.
Thanks.