AnsweredAssumed Answered

How to work with JOBS/JOBP-aliases?

Question asked by StephanMannert82415952 on Mar 14, 2018
Latest reply on Mar 15, 2018 by MatthiasSchelp
Hi,

I want to build one generic workflow for backing up several MSSQL databases/instances.
So I have only three very generic jobs with some variables:
LOGARCHIVE_DB_MSSQL#JOBS_WIN
BACKUP_DB_MSSQL#JOBS_WIN
BACKUP_FS#JOBS_WIN
And I want to activate these jobs with aliases like, e.g.
"LOGARCHIVE_DB_MSSQL#JOBS_WIN#HOSTNAMEXY"

But I have the problem, that I can't control how many times the jobs are allowed to start in parallel. Functions like SYS_STATE_ACTIVE needs always the object-name and an alias is not possible.
But I want to avoid to create a workflow/job for every single database/instance.

Any ideas/help for me? Is it possible? With which version? We use version 9 and 10.

Best regards
Stephan

Outcomes