query to find the parent group name

[Warren Tolentino]

what is/are the table name that i should use to find the parent name of the job?

thank you,

warren

[Derrick Au]

Hi Warren,

The parent group name (dbo.jobmst.jobmst_prntname) can be found within jobmst table.

For example, the below query will return parent name of a specified job:

SELECT dbo.jobmst.jobmst_prntname

FROM dbo.jobmst

WHERE dbo.jobmst.jobmst_name = 'Enter name of job here'

BR,

Derrick Au