Can't Schedule an agent-Please help

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!