Use the below SQl for finding the job when the trigger name is given.
SELECT ROBOT_JOB_NAME FROM rbtrob WHERE ROBOT_JOB_NUMBER in
(SELECT CMD_SET_NAME FROM rbtcs WHERE CMD_SET_OID in
(SELECT CMD_SET_OID FROM rbtcmd WHERE CMD_STRING like '------------------------------------------------------------%'))
SELECT ROBOT_JOB_NAME FROM ROBOTLIB/rbtrob WHERE ROBOT_JOB_NUMBER
in (SELECT CMD_SET_NAME FROM ROBOTLIB/rbtcs WHERE CMD_SET_OID in
(SELECT CMD_SET_OID FROM ROBOTLIB/rbtcmd WHERE CMD_STRING like
'AMBR%'))
SELECT * FROM ROBOTLIB/rbtcmd, ztcsdev1/imacptfil1 b
where CMD_STRING like concat(concat('%',trim(b.SRCDTA)),'%')
SELECT SYSTEM, JOB_NAME, JOB_DESCRIPTION, COMMAND_LINE FROM
rbtrobv01 WHERE command_line like '%XXXDZ58%'