Understanding how the cleanup tasks work now rather than before we created
the jobs makes this a much better idea. We may well have to change our
backups to just do the one cleanup job a day.

Thanks

Chris

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:u5QsnqBkIHA.5820@TK2MSFTNGP04.phx.gbl...
>>> We run maintenance plan created SSIS packages to backup our databases.
>>> The final step is the cleanup of the jobhistory. We see the occasional
>>> deadlock coming from sp_maintplan_delete_log.
>
> Is it possible that two maintenance plans are calling this procedure
> at/around the same time? If so, my suggestion would be to create your own
> job that deletes ALL maintenance plan logs, say once a day, by passing in
> only the @oldest_time parameter. And then set each maintenance plan to
> not delete its own logs.
>