How to identify a Job Server y Parallel

jseclen · Post by **jseclen** » Tue Sep 23, 2008 4:09 pm

Hi Forum,

I'm using the DSGetJobInfo Function to obtain information from jobs, but this function dont return the job type (server or parallel), this attribute is important for my process because i need analize the job server and parallel for separate.

I expect for your answer.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 23, 2008 4:19 pm

There is a column called JOBTYPE (or JOBTYPEIND) in the DS_JOBS table.

Code: Select all

SELECT JOBTYPEIND FROM DS_JOBS WHERE NAME = '<<Job name>>';

chulett · Post by **chulett** » Tue Sep 23, 2008 4:32 pm

Search the forums for JOBTYPEIND to get a list of 'valid values'.

jseclen · Post by **jseclen** » Tue Sep 23, 2008 4:34 pm

Thanks Ray,

I need make a routine to obtain this atribute or there is a function to make this select???

chulett · Post by **chulett** » Tue Sep 23, 2008 4:41 pm

You could run the query using DSExecute with the ShellType set to 'UV'. And that from inside your existing routine that is calling DSGetJobInfo, I would assume.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 23, 2008 5:31 pm

Or you can use SQLExecDirect() with @HSTMT as the statement handle.

abc123 · Post by **abc123** » Tue Sep 30, 2008 8:06 am

Ray, I did the SELECT on one of my jobs and I get:

Reserved
3

What does that mean? Which document should I look up these values/commands in?

chulett · Post by **chulett** » Tue Sep 30, 2008 8:20 am

What does what mean, the '3'? Did you search the forums for JOBTYPEIND, that will turn up the list of values.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 30, 2008 3:34 pm

What query did you use? I suspect you got it right - you can override the column heading ("Reserved" is the default column heading). And, yes, job type is enumerated: from memory they decode as 0 = server job, 1 = mainframe job, 2 = job sequence and 3 = parallel job.