How to delete DTS package logs older than N months?

• jon-168559

  SSC Enthusiast

  Points: 100

  More actions

  June 5, 2007 at 10:07 pm

  #124173

  How to delete DTS package logs older than N months? I plan to schedule this cleanup to maintain msdb size. Thanks.

• Pradeep Kumar-289326

  Valued Member

  Points: 56

  More actions

  June 7, 2007 at 4:28 am

  #711361

  I think this stuff is gonna sit in sysdtspackagelog and sysdtssteplog tables in MSDB database.

  There would be also few other tables starting with "sysdts" check them out too.

   

  # "sp_dump_dtslog_all" can be used to dump all package logs

  # "sp_dump_dtspackagelog" to dump a specific package log

   

  Cheers.... -Deeps