Can a scheduled agent call another scheduled agent in a different database —??And can a scheduled agent reference a view in a different database?
I have to figure out a way to allow someone to select an employee for archive in one main db and have the system go thru about 4 different databases to make field changes on each of that person’s docs to archive them.
I just don’t know the most efficient way to go about this.
Subject: Scheduled Agent…
Can a scheduled agent call another scheduled agent in a different database — Yes, but just as an agent, as it would not really be scheduled if you are calling it
And can a scheduled agent reference a view in a different database? — Yes
Using Lotus Script, you can get a NotesDatabase object for the other database, and using that, you can call it’s agents and access it’s views.
Note that you may have issues if those different databases are on different servers. Look into how Servers need to trust each other to allow scheduled agents to access databases on different servers.
Subject: Scheduled Agent…
One possible solution:- set a ‘magical’ field in profile doc in all databases to be archived
Just out of curiosity, what kind of archiving system is that?
Subject: RE: Scheduled Agent…
Well, it’s not really “archiving”. I actually already have an archiving system set up. It’s really just taking old employees and removing them from the view of others. So I either need to change the contents of the readers field or change the fields that are referenced in the Readers Field (i.e. Mgr Name).