Configure Maintenance Plans Logs

I want to limit the total size of my Maintenance Plan logs by eliminating all entries older than 1 year.

Isn't there a simple way to do this through the SQL Server Management Studio GUI?

When I right click on SQL Server logs (Maintenance Plan logs are not part of this), a config window pops up which offers to limit the number of SQL Server logs, but I don't see an equivalent way of limiting the Maintenance Plan logs.

And in any case, this would not allow me to set a maximum age for entries.

What's the simple way of limiting the age of maintenance plan log entries?

Thanks in advance.
Who is Participating?
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
You can  create a maintenance plan task to clean up the Logs there is already a task which does these
dakota5Author Commented:
Didn't notice this.  Thanks much.
dakota5Author Commented:
Actually, no.  The maintenance plan cleanup task is for the optional text files that maintenance plans can generate.  Not for the main logs themselves.

I'm going to resubmit the question.
dakota5Author Commented:
Maintenance Plan Tasks-toolbox | History Cleanup Task does the logs.  You were correct.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.