Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

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
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.