Kbase P99153: How to run multiple scheduled CorVu queries against different databases at the same time.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/2/2010 |
|
Status: Unverified
GOAL:
How to run multiple scheduled CorVu queries against different databases at the same time.
GOAL:
How to run two CorVu schedules against different databases at the same time.
GOAL:
Permissions on CorVu scheduled queries
FIX:
This isn't possible using the CorVu-internal Scheduler.
Instead, an os batch job has to be set up (in notepad and saved as a .bat file type) which tells CorVu to start up, what to connect to, what to log in as, e.g.
c:\corvu\kilsrv32.exe
c:\corvu\corvu32 "database1 server name" "login name" "login password" "corvu schedule filename"
c:\corvu\corvu32 "database2 server name" "login name" "login password" "corvu schedule filename"
c:\corvu\kilsrv32.exe
The Windows Scheduler should be used to start it when required.
Because CorVu is normally installed centrally, it can only open and run one query at a time. In the example above, the first query will run, CorVu will shut down, and then restart and run the next.
Security will have to be handled at the os levels by means of file permissions. The batch jobs should be set up so that other users can run them, but only the designated administrators can open them for reading/editing.