Get maintenance plans info and It's by effect jobs

I have been wonder how to get info (by query NOT EM) of all the Maintenance Plans and it's by effect jobs plus schedule. I also see people asking the same questions in different forums. Finally, I start exploring myself (with helps from others of course), here's the result.You can run it as a ad-hoc […]

2006-01-27 (first published: )

292 reads

Blogs

Daily Coping 9 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Webinar: How to unlock the value of frequent deployments

By

I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...

SSMS 18.5 Fixes from Redgate

By

I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...

Read the latest Blogs

Forums

ALWAYS On Setup problem

By interest

While configuring N1 and N2  Nodes connected to DC  Domain Controller working fine. Establishing...

Do You Have a Mentor?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Have a Mentor?

Counting Rows in DAX

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Rows in DAX

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers