I want to get the infomation about if a job is executing at this moment from the database server. I know that command
ctmpsm -LISTJOB executing
do what I need, but I have to run a SQL script that obtain the same information than this command does.
I suppose that is something like this:
SELECT <what> FROM cmr_ajf WHERE status = ? AND state = ?
I would like to know if it can be resolved with status = N and state = 5, but I don´t know what this status and state means, so please can you help me?
Are this status and state ok? What does it mean?
Is this SQL query ok?
Thanks in advance.