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

What Agent Jobs are Running??

By

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

Unboxing SQL Clone 2020 for a PoC

By

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

Daily Coping 4 Aug 2020

By

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

Read the latest Blogs

Forums

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...

ALTER DATABASE Issue

By genadyd

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

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers