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


What Agent Jobs are Running??


Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC


When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs


THROW vs RAISERROR with bubbling up

By Mark Eckeard

Hi all, I know THROW is newer and recommended but I'm wondering if one...

Azure SQL - Handling JSON column in the table

By mohankumar.trs

Hi I want to convert table content which contain the json values in the...


By genadyd

Hello, I faced  very strange issue. When I try from management studio to put...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers