Link to home
Start Free TrialLog in
Avatar of skull52
skull52Flag for United States of America

asked on

Display SQL maintenance plan SQL Code

I have a large number of SQL maintenance plans on a database, I need to move a select few to a new database, I would like to run a script that will tell me what code the Plan is running (i.e actual code or calling a Stored Procedure) without having to open each plan. I am running SQL Server 2008R2
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of skull52

ASKER

yeah... that's what I was afraid of.