Query To Locate Action Variable Being Called From

[Warren Tolentino]

we have this "M011 - 0" action variable that resets the value back to 0. i can't seems to find where this action variable is being called from the tidal. i looked at every places and failed to locate it. does anyone have a SQL query to find where this piece of info can be located?

thank you,
warren

[Marc Clasby]

Try the Query that joins events and actions to find your event... then you can do a similar query to find jobs

Marc

SELECT dbo.tskmst.tskmst_name AS [Action Name], dbo.trgmst.trgmst_name AS [Event Name]

FROM dbo.trgmst INNER JOIN

dbo.trgtsk ON dbo.trgmst.trgmst_id = dbo.trgtsk.trgmst_id RIGHT OUTER JOIN

dbo.tskmst ON dbo.trgtsk.tskmst_id = dbo.tskmst.tskmst_id

WHERE (dbo.tskmst.tskmst_name LIKE '%M011%')