Have a scheduled agent that I have been having some issues with. This is one that sends out letters overnight. This database has office records, about 300 and that is the one that these are referencing. In the database there also a large number of user records. The problem appears to be that there are now too many records in the database. The Agent Log shows 7600 total records and the error is "Maximum allowable documents exceeded for a temporary full text index". Problem here is we use this database each year and half of the user records are from last year and we are hoping to keep the 3000+ user records for historical purposes.
What is the maximum that will work on an agent? And what options do I have here to get this to run? The option on the agent to run on New & Modified Docs just won't work.