Safely delete package logs?

• Larry Stein

  Default port

  Points: 1447

  More actions

  September 13, 2004 at 8:41 am

  #60192

  I want to automate deltion of old package logs.  I know something about the sysdtssteplog and sysdtspackagelog tables in the msdb database.  Can I safely delete from those two tables?  Are there other tables that must be addressed also?  Any other suggestions?

  Thanks,

  Larry

  Larry

• philcart

  SSC-Forever

  Points: 47796

  More actions

  September 14, 2004 at 5:32 pm

  #523087

  Take a look at my script here,

  http://www.sqlservercentral.com/memberservices/updatescript.asp?Approve=y&scriptid=606

  This removes old versions of packages and their related logs. You can modify this to just remove the logs if you like. There is probably a script to do just that somewhere in the script library.

  --------------------
  Colt 45 - the original point and click interface