Tip: Get database agent status with one click!

This tip describes three ways in which you can create an action button that lists the agents in the current database and the agent status, including the day and time that the agent was last run. Code examples and a download sample are available with this tip.

Donald Russell, Advisory Software Engineer, IBM Corporation

Donald Russell is an Advisory QA Engineer for Lotus Education and has been working in IBM's Lotus Software division since 1996. Prior to his current position, Donald was an advisory IS application developer and a senior Premium Notes Support Analyst. He holds a Bachelor of Science in Electrical Engineering and is a Certified Novell Administrator. Donald has written over 500 technical documents and white papers for the IBM DCF and Lotus Knowledge Base and has published technical articles for The View magazine. Outside of work, Donald was a Cub Scout Den leader and now an Assistant ScoutMaster for the Boy Scouts .



15 November 2004

If you want an easy way to see which agents you have in your database and what each agent's status is, use the methods described in this tip to implement a simple solution. To check the database agents, you can use any one of these three solutions:

  • Agent Status Query allows you to select the agent from which to get last run date and time and the agent signer. The following screen shows the names of the agents in the database when you click the Agent Status Query button.
    Figure 1. Database agents dialog box
    Database agents dialog box
    When you select an agent in the previous screen and click OK, agent status is shown as follows:
    Figure 2. Agent status dialog box
    Agent status dialog box
  • All Agent Status Report shows a report that lists all agents in the database, their last run date and time, and the name of the agent signer. The following screen shows the result of clicking the All Agent Status Report button. The results display the agent name, last date and time the agent ran, and the agent signer.
    Figure 3. Database agents dialog box
    Database agents dialog box
  • Specified Agent shows where the agent name is coded. The following screen shows the resulting message prompt when you click the Specified Agent button.
    Figure 4. Database agent dialog box
    Database agent dialog box

You can implement these solutions as LotusScript buttons. They require a minimum of Reader access in the database ACL. The LotusScript code for each button can be added to action bar buttons in a form or view or to an RTF field on a Notes form. You can even place the LotusScript buttons in the RTF body field of a mail memo or any document in a Notes database!

You do not need Designer or Manager access to the database to implement this code. You don't even need Domino Designer to see the results! Download a sample application containing the buttons from the Sandbox.

To view the LotusScript code for each button, click the following links:

Resources

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into IBM collaboration and social software on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Lotus
ArticleID=31761
ArticleTitle=Tip: Get database agent status with one click!
publish-date=11152004