April 6, 2011 at 11:56 pm
Jeffrey Williams-493691 (4/6/2011)
CirquedeSQLeil (4/6/2011)
Jeffrey Williams-493691 (4/6/2011)
I found a way to relate maintenance plans to their associated agent jobs. It is quite simple...The job_id is stored in the table: sysmaintplan_subplans and can be used directly to get the actual job created for the sub-plan.
Note, this only works for maintenance plans - and does not give you the job for SSIS packages.
well that is a bit simpler than what I did for the maint plan at least.
Yes - but does not include the jobs associated with SSIS packages. Makes sense, because you don't create a job from a package, but you do create a job from a maintenance plan.
I like what you did - but would probably only use it to identify the jobs that are related to any SSIS packages. Since most of the time I only need to worry about maintenance plans - this really never came up. I know what those plan names are and don't really need to get it in a query.
Agreed. It's just another tool for identifying those jobs.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply