September 27, 2016 at 11:56 am
Apologies for the stupid question -- where do I go to see if a SQL Server instance has an <i>existing</i> maintenance plan? Strangely, I haven't been able to find a good answer to this.
I don't need to know about maintenance plan settings or configs -- I just need to know whether it's there or not.
Thanks!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 27, 2016 at 1:26 pm
Ray K (9/27/2016)
Apologies for the stupid question -- where do I go to see if a SQL Server instance has an <i>existing</i> maintenance plan? Strangely, I haven't been able to find a good answer to this.I don't need to know about maintenance plan settings or configs -- I just need to know whether it's there or not.
Thanks!
You can query sysmaintplan_plans in msdb.
Or in Object Explorer, go to Management then to Maintenance Plans.
Sue
September 27, 2016 at 1:33 pm
Sue_H (9/27/2016)
Ray K (9/27/2016)
Apologies for the stupid question -- where do I go to see if a SQL Server instance has an <i>existing</i> maintenance plan? Strangely, I haven't been able to find a good answer to this.I don't need to know about maintenance plan settings or configs -- I just need to know whether it's there or not.
Thanks!
You can query sysmaintplan_plans in msdb.
Or in Object Explorer, go to Management then to Maintenance Plans.
Sue
Great -- thanks!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply