It is currently 17 Dec 2018 5:47

Post new topic  Reply to topic  [ 2 posts ] 
Author Message
PostPosted: 08 Jan 2008 6:00 

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.

 Post subject:
PostPosted: 08 Jan 2008 8:20 
User avatar

Joined: 03 Jan 2008 12:00
Posts: 52
Below is the STATE list:

0-wait schedule
1-wait confirmation
3-not submitted
8-post processed
9-not found
A-wait rerun
B-wait time
C-wait cond
D-wait resource
E-wait submission
G-retry submission
J-wait odat
k-post odat

As you can see the executing state is 4. What you probably want is:

select <what> from CMR_AJF where STATE='4'

STATUS is either NULL, Y, or N.

NULL - not ended
Y - ended ok
N - ended notok

You probably do not want to include the STATUS in the selection for executing.

Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 2 posts ] 

All times are UTC+01:00

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by All Rights Reserved