Hi,
I need to write a scheduled agent that runs once every month. The purpose of this agent is it should run through all the documents in a view and if the document creation date is less than 2 months, it should delete the document from the database.
Ideally speaking if the agent runs on Nov’ 1 2006 then it should remove all documents created before September ’ 30 2006.
Can anyone help me with the code.
Thanks in Advance.
Subject: Scheduled Agent
In the reservation database, there is a purge agent that delete documents older than a certain date, i think it’s a godd start
JYR
Subject: RE: Scheduled Agent
Sample LotusScript code that can be used to delete documents that are a number of days oldhttp://www-1.ibm.com/support/docview.wss?rs=475&context=SSKTWP&dc=DB520&uid=swg21214103&loc=en_US&cs=UTF-8&lang=en&rss=ct475lotus
JYR
Subject: RE: Scheduled Agent
Hi,
Do the following:-
-
Make a copy of Database in another folder , named \Archive
-
Open Database u want to archive, create a view and write SQL quiery, which will contain all the documents u want to archive.
-
Creat a new agent for example :- Test, click on Add action, from Action select copy from database – , and same way create another action for Delete from Datbase.
Save the Agent.
-
Then schedule the agent.
-
All the steps are not mention clearly, try to uderstand and do it . I think u will get solution definetly.
Regards
Jai