REL =waitEvents.<Event>. Jobname?

[Former Member]

Hello,

how can I get the jobname of a job which raised an event with REL?

The jobId I can get with =waitEvents.<Event>.raiserJobId.

At the moment I extract the jobname from "waitEvents.<Event>.raiserComment" with "substring" and "indexOf", but I hope there could be a better possibility.

Thanks and best regards

Dana

[h_carpenter · Accepted solution]

Hi Dana,

You can see the REL functions in http://<server>:<port>/scheduler/help/model/rel_functions.html

Look, the example for Query.getString() retrieves the jobname:

=Query.getString("select Job.Description from Job where Job.JobId = ? ", waitEvents.<Event>.raiserJobId)

Regards,

HP

[Former Member · Accepted solution]

Hello HP,

many thanks for your help!

The URl was saved and the Query.getString() tested. It works!

I only inserted [ ] around the bindVariables.

Thanks and best regards!

Dana