Can we get only job status???

[ArndW]

That looks sufficient - have you tried it?

[moose2079]

hmmm... that last post needs to be corrected!

The command to execute had 2 errors, it should read:

Code: Select all

Call DSExecute("UV","SELECT NAME FMT '60R' FROM DS_JOBS WHERE NAME NOT LIKE '%\%';",output,sysretcode) 

Your output variable "output" will contain a multivalued list of the jobs located. You can then do something like:

Code: Select all

JobsFound = DCOUNT(output,@FM)
FOR I = 1 TO JobsFound
  JobNameToCheck = output<I>
  ** do your processing here **
NEXT I