How To Get Information On SQL Maintenance Plans Job Steps



3Comments

TODO:

Have you ever wanted to get information on SQL Server Mainenance Plan job steps using T-SQL?

 

SOLUTION:

select * From msdb..sysjobs

 

 

NOTES:

There are no notes on this topic.

By Kilimanjaro on December 29, 2011 at 3:33 PM
Tagged: , , ,



Comments (3) -

Reply
John
John
3/20/2012 2:43:53 PM #

Problem is that this is not a Maintenance Plan listing, this is a SQL Agent Jobs listing.  Although the Maintenance Plans run ultimately as Jobs, this listing of information does not dissociate between a distinct Job and a Maintenance Plan Job.

Please revise this to show the correct syntax.

Reply
Taller de mantenimiento
Taller de mantenimiento
5/18/2012 2:30:08 PM #

Very interesting post….really informative…..of all the blogs I have read on the same topic, this one is actually enlightening….I was longing to read such kind of informative write-ups from a very long time…good to know that such kind of posts are there to help ignorant and novice people.

Reply
Taller de mantenimiento
Taller de mantenimiento
5/21/2012 8:04:17 AM #

Very interesting post….really informative…..of all the blogs I have read on the same topic, this one is actually enlightening….I was longing to read such kind of informative write-ups from a very long time…good to know that such kind of posts are there to help ignorant and novice people.

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading