Scheduled Agent Not Working

Posted on 2005-05-12
Last Modified: 2013-12-18

I'm trying to understand possible reasons why this scheduled agent is not working.  I have it scheduled to run every hour.   I have visually verified that there are documents in the database that meet the criteria.  This doclink should be sent to the users shown when today is one day past the due date.
The only relevant field is DueDate

SELECT Form = "Issues" & (@Now - DueDate > 84600);

@MailSend("John Smith" : "Anita Jones" ;"";"";"Unresolved Past Due Issue: "; "This issue is now 1 day past due.";"";[IncludeDoclink])

Any help is appreciated.  Thanks!
Question by:Aquilon7
    LVL 31

    Accepted Solution

    First try setting it up to run from Action menu, and see if it works correctly when run manually.

    Another plan of debug attack:
    On scheduled agent, instead of @MailSend, have it set a dummy field on the document, so you can see if it ran.  Verify that it works, change the dummy field to another value, Or, do both -- first have it set the dummy field, then have it @MailSend.  MailSend shoudl eb second, in case only the MailSend fails, and the dummy value shoudl be changed form teh first run (where there was no MailSend attempted) so you can distinguish between them.

    Note: If you set this to run every hour, it will send duplicate messages every hour, because the same document that macthed an hour ago will also match now.  Did you really want to do this?
    LVL 3

    Expert Comment

    From the designer, right-click on the agent name and select "Log...". does it indicate that the agent has run before?  (Note: Each time you re-save the agent, this log is cleared).

    If not, make sure your agent is set to run on the proper server, and check that the signer of the agent is permitted to run agents on that server.

    You can also run 'tell amgr schedule' at the server console to see what the agent manager is running and has scheduled.

    Regarding your code:
    Why not use @Adjust?

    SELECT Form = "Issues" & (@Now - DueDate > 84600);


    SELECT Form = "Issues" & (@Now > @Adjust(DueDate;0;0;1;0;0;0);
    LVL 31

    Expert Comment


    > Why not use @Adjust?
    Yes, why not? Well, he could also use any of:
    SELECT Form = "Issues" & (@Now > @Adjust(DueDate;0;0;0;24;0;0);
    SELECT Form = "Issues" & (@Now > @Adjust(DueDate;0;0;0;0;1440;0);
    SELECT Form = "Issues" & (@Now > @Adjust(DueDate;0;0;0;0;0;86400);

    ALl five are the same, so no need to change! Just a matter of style.

    - qwaletee

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
    This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now