November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Delete logdata from database

Vote:
 
Hey I want to clean the database for logdata, but I need documentation. Anyone who know where I can find documentation for database or have done this before? Thanks, André Brynildsen
#13180
Aug 29, 2007 10:43
Håkan Alexander
Håkan Alexander
Vote:
 
Here you go! Regards HAXEN DECLARE @ScheduledJobName varchar(50) DECLARE @ScheduledJobGUID uniqueidentifier SET @ScheduledJobName = 'EPiServer Subscription Job' SELECT @ScheduledJobGUID = pkID FROM tblScheduledItem WHERE [Name] = @ScheduledJobName DELETE FROM tblScheduledItemLog WHERE fkScheduledItemId = @ScheduledJobGUID DELETE FROM tblScheduledItem WHERE fkScheduledItemId = @ScheduledJobGUID
#15502
Aug 30, 2007 10:51
Vote:
 
I'm searching for tables which is used by "Log Service" (log4Net), not history logs for "Scheduler".
#15503
Aug 31, 2007 13:10
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.