Sunday, March 2, 2014

MSSQL Maintenance Plans - Tip: Have the task name displayed in your logs

When viewing the history of a Maintenance Plan job, the name of each task can be blank making it tricky to know which row relates to which task.


When creating the Maintenance Plan task, unless a "Task Name" is specified (Properties on the specific task), no name will be displayed within the plans history. 


By adding a "Task Name", your plan history will display the task name at the row level. This helps make the plans history more readable at a glance.