abel5405 Absent Member.
Absent Member.
1938 views

Query to list what job an action is assigned too.

I thought I saw this on the forms before but I did a search with no joy. Is there a query I can use to see what jobs an action is assigned too? I'm trying to hunt down what an action is assigned too and I can't find it. Many thanks in advance for your help.

v/r
Chris
Tags (1)
0 Likes
1 Reply
Micro Focus Expert
Micro Focus Expert

Re: Query to list what job an action is assigned too.

abel5405 on 3/5/2018 at 9:14:03 AM wrote:

>
>I thought I saw this on the forms before but I did a search with no
>joy. Is there a query I can use to see what jobs an action is
>assigned too? I'm trying to hunt down what an action is assigned too
>and I can't find it. Many thanks in advance for your help.
>
>v/r
>Chris



This should give you what you are looking for:

SELECT
ActionTmpl.ActionName
, Job.JobID
, Job.KSName
, Object.Name
FROM
ActionTmpl
INNER JOIN
Job
ON
ActionTmpl.OwnerJobID = Job.JobID
INNER JOIN
Object
ON
Job.MachineObjID = Object.ObjID
and ActionTmpl.ActionName like 'Action_SMTPMail'
--- Replace Action_SMTPMAIL with the desired action


--ebell
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.