1

Need to edit a maintenance plan backup cleanup job.

It can't find any place to edit the job through a Query editor.

How can this be done without disabling the job and creating your own job?

tia.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Mang G11
  • 219
  • 5
  • 12

1 Answers1

3

Given the right permissions, you should be able to go into your Object Explorer, find the maintenance plan in question, and Modify it:

enter image description here

and on the maintenance plan diagram, you should be able to just double-click on the Execute T-SQL Statement Task box to edit the T-SQL statement:

enter image description here

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459