How to get Job Type (Sequence, Server or EE Job)

nick.bond · Post by **nick.bond** » Tue Jun 27, 2006 12:01 am

Given a job name is it possible and if so what is the BASIC code to find out what the "type" of job it is from within a routine.

i.e. is it a Server Job, an Enterprise Job or a Sequence Job.

Thanks, Nick.

ArndW · Post by **ArndW** » Tue Jun 27, 2006 12:38 am

The job type resides in a column in the DS_JOBS file. I don't know of any published API routine such as DSGetJobInfo() whre this information is available, so the only way to get this would be to read the DS_JOBS file - and that will only work until the repository is changed at version 8.

You can either open the DS_JOBS file and read the record or you can issue a SELECT statement. The SELECT is easier and more future-proof in that it might be easily changed, reading the DS_JOBS is somewhat faster.

You might need to change my code around, as I am not at a DataStage machine and am typing freehand.

Code: Select all

   OPEN '','DS_JOBS' TO DsJobsFilePtr ELSE CALL DSLogFatal('Unable to open DS_JOBS file, status is ':STATUS(),'')
   READV JobType FROM DsJobsFilePtr, JobName, 6
   ELSE
      JobType = '?'
      CALL DSLogWarn('Unable to find job "':JobName:'" in DS_JOBS.','')
   END
   CLOSE DSJobsFilePtr

JobType 0 is a Server, 2 is a Sequence and 3 is a PX Job.

The other method is to issue a

Code: Select all

   EXECUTE 'SELECT JOBTYPE FROM DS_JOBS WHERE JOB = ':JobName:';' CAPTURING Output RETURNING ErrorCode

The string "Output" will have the text and you need to parse the job type from that string.

kumar_s · Post by **kumar_s** » Tue Jun 27, 2006 12:41 am

You have JOBTYPE in DS_JOBS to indicate this.

Server jobs - 0
JobSequnce - 2
PX Jobs - 3

ray.wurlod · Post by **ray.wurlod** » Tue Jun 27, 2006 12:51 am

In case anyone is wondering, 1 is mainframe job.

DSguru2B · Post by **DSguru2B** » Tue Jun 27, 2006 6:55 am

Actually i was. Thanks Ray. You really working on the RMM stage arent you

chulett · Post by **chulett** » Tue Jun 27, 2006 7:01 am

That stage may be here sooner than you think!

DSguru2B · Post by **DSguru2B** » Tue Jun 27, 2006 7:04 am

Wow. An intelligent computer that can read a persons mood just by the motion of the eyebrows. O they will have to do better than that to even come close to RMM stage

nick.bond · Post by **nick.bond** » Tue Jun 27, 2006 7:51 pm

Thanks.

p.s. what's RMM?

kcbland · Post by **kcbland** » Tue Jun 27, 2006 7:55 pm

Read My Mind