I am looking for a way to execute a series of registration jobs automatically in a workflow. Each of the jobs shares a similar name, and I want them to be executed as an initial step in a workflow to be sure all of the products installed are registered in a static variable.
Currently, I am exporting the list of jobs to a file,
:SET &OBJECT# = "CATALOGS_*_REGISTER_LOADER_TYPE"
:SET &FILE# = "&WIN_WORKING_DIR#\jobs.tmp"
:SET &RET# = EXPORT(&OBJECT#,&FILE#)
then parsing the file, but this is a bit awkward, and looks prone to failure in the future.
I would like to use a query variable to get a list of the matching jobs and then iterate through the returned variable, but I do not know which table to use.
SELECT objectName FROM [table] WHERE client=&$CLIENT# and objectName LIKE ‘CATALOGS_%_REGISTER_LOADER_TYPE’
A table name to use would be greatly appreciated.