Scheduling tasks in a routine database and not in the ECP

Question

Edmara Francisco · Oct 3, 2023

Hello,

I need to ensure that the task created/scheduled, by system user, is created in the routine database and not remotely in the ECP to which it is connected. How can I guarantee the creation/scheduling of this task?

Here is a suggestion for creating the routine in both environments:

https://openexchange.intersystems.com/package/Background-Jobs-ECP

Is there another option?

Product version: Caché 2018.1

Discussion (2)2

Enrico Parisi · Oct 3, 2023

When a new task is created in System Management Portal (SMP) there is a field:
"Namespace to run task in"

The task will run in that namespace, to find what database it corresponds to check the namespace definition.

Enrico

1 0

Robert Cemper · Oct 3, 2023

I suggest to have globals and routines in separate databases.
Keep the routines always local and only use Global DB over ECP for shared access.
The price is you have routines to maintain in 2 instances.

1 0