Ola's SQL Server Maintenance solution - commandlog cleanup

• lawson2305

  SSCommitted

  Points: 1624

  More actions

  October 6, 2014 at 1:16 pm

  #297184

  I have searched up and down and can't find anything regarding this topic.

  Am I missing something if so please let me know. If not please what are your suggestions for cleaning up this table created using Ola's tools and logging the output to the table in the Master db.

  Thanks for any suggestions or help.

• lawson2305

  SSCommitted

  Points: 1624

  More actions

  October 6, 2014 at 1:22 pm

  #1750393

  Found a job created called Commandlog Cleanup

  Doh

  I searched and searched for info on the site never found anything.

  Here is the SQL if anyone is interested:

  sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "DELETE FROM [dbo].[CommandLog] WHERE DATEDIFF(dd,StartTime,GETDATE()) > 30" -b