[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Scheduled agents and the documents they run on

Posted on 2006-06-15
9
Medium Priority
?
375 Views
Last Modified: 2013-12-18
Greeting learned ones,

I was about to schedule an agent to run on a weekly basis but then wondered how exactly does a scheduled agent work. You set the schedule and then you select either all documents in the database or all new and modified documents. And yet I don't want the agent to run on either of these choices. My agent grabs information from databaseB, checks it against documents in a specific view in databaseA and if a doc does not exist in databaseA but does in databaseB, it will create the doc in databaseA. So I should be able to go ahead and run this agent? Anything to look out for other than UI type functions? Thank you.
0
Comment
Question by:notesrookie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 15

Expert Comment

by:mshogren
ID: 16914917
Hi,

If you are using Lotusscript in your agent then your document does not run on all document or all new and modified documents unless you use the UnprocessedDocuments property of the database object.  Those options are intended more for formula agents.

Your agent sounds like it should run fine.  One thing to consider is whether or not databaseA and databseB are on the same server.  If not then you may have to change the security settings on the server documents in order for and agent on one server to operate on a database on another.
0
 
LVL 18

Expert Comment

by:marilyng
ID: 16915263
How many documents are you running through?  And what is the average time spent, so that you don't exceed the agent time - most servers have a maximum agent time set, and if you exceed it, then the agent shuts down.  While it generally runs fine at first, when the databases accumulate documents, they get slower.

So, agent takes too long to process.. is another one.  It shouldn't create duplicates from the sound of it, and if it runs when nothing else is running then you shouldn't get replication conflicts.
0
 

Author Comment

by:notesrookie
ID: 16936313
I looked at the ACL in databaseB and saw that the server that databaseA is on will not be able to open databaseB. It only allows a selected group reader access to it and I am a part of that group but not the server. If I sign the agent will that allow the agent to do what it needs to do? Thanks.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 15

Expert Comment

by:mshogren
ID: 16936489
Yes it should work if you sign it.
0
 

Author Comment

by:notesrookie
ID: 16938258
Unfortunately, signing the agent, running on behalf of and allowing restricted operation with full administrator rights did not work. Is there anything else that I should try? I know it works but only if I run it from my Notes client. It won't run when scheduled on the server and it specifically stops at the point where it is trying to open the databaseB. Thank you.
0
 
LVL 15

Expert Comment

by:mshogren
ID: 16938415
There should be an error message in the log.nsf database if the agent is not running properly on schedule.  If you tell me what that message is I should be able to help a little more.
0
 

Author Comment

by:notesrookie
ID: 16938575
Basically I coded the agent so that if it is unable to open the database, to exit the procedure. The portion of the agent involved is

ServerName = "Server/Domain"      
dbReplicaID = "852570EE006801F3"
Dim db As New NotesDatabase ("", "")
If db.OpenByReplicaID(ServerName, dbReplicaID) Then
      Print (db.Title & " was successfully opened")
Else
      Messagebox ("Unable to open " & db.Title & ". This procedure will now exit.") *
      Exit Sub
End If

The notes log shows the * lines above. Before I coded it this way the error message I received was AMgr: Agent ('SomeAgent' in 'path\databaseA.nsf') error message: Database ServerB!!path\databaseB.nsf has not been opened yet.
 Thanks.
0
 
LVL 15

Accepted Solution

by:
mshogren earned 500 total points
ID: 16943271
Are databaseA and databaseB on different servers?  That would require you to add serverA to the Trusted Servers field at the bottom of the security tab in the Server document for ServerB
0
 

Author Comment

by:notesrookie
ID: 16943687
Yes they are and I will not be able to add serverA as a trusted server on serverB's server doc. I guess that answers my question. Thank you.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

650 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