Hi ,

 

I know you can manually delete chat log from db from chat administration page, but i want to delete the chat  log automatically  , is there a way?

 

Kind regards

Dear tajamal,

 

You can create a stored procedure which deletes the data you wish to delete.
Next create a job which executes the stored procedure. You can schedule the job to run once a week, or on any day in the week you wish.

A new job can be created in SQL Server Agent.To tell the job to execute your stored procedure:
Add a new step. Give it a name like 'Step 1: delete data from myTable'. Select the right database. In command box type: EXEC the_name_of_your_stored_procedure

 

Thank you for asking

Eric@cutesoft.net

Thanks Eric, That's what i had in mind to do next.  I was fishing after something in cutechat itselft, caus it saves a log in table so i thought it will be obvious to delete the chat at a given time too from cutechat itself.

 

Kind regards

Tajamal