I wrote an agent which works if run manually. It is:SELECT View=Transmissions\Date;
timenow := @Now;
@If(@Date(QUEUEDATE) < @Date(@Adjust(timenow;0;0;-30;0;0;0));@DeleteDocument;OK)
Problem is I can’t get it to run if scheduled to run daily. No one here can figure out why.
Subject: There are at least 2 things wrong with this formula.
SELECT View=Transmissions\Date;timenow := @Now;
@If(@Date(QUEUEDATE) < @Date(@Adjust(timenow;0;0;-30;0;0;0));@DeleteDocument;OK)
First off the SELECT View=Transmissions\Date; ? What do you intend this to do? Do you really have a Field called View in the documents in question? If so, you should be testing against View = “Transmuissions\Date” (note the ""s). Second, The OK at the end of the If? I assume you really just want “”. The way I would write this is
SELECT Form = “YourForm” & @Date(QUEUEDATE) < @Date(@Adjust(@Now; 0; 0; -30; 0; 0; 0));
@DeleteDocument
Subject: Can’t Schedule an agent-Please help
Solved it. The database wouldn’t allow background agents to run. Whew!