• In Management Studio, under Management -> Maintenance Plans, open your maintenance plan. Double click or Edit the task that you want to view. At the bottom of the box that pops up is a "View T-SQL" button. Hit that and it will show you what's running behind the scenes.