DSGetJobInfo

subrat · Post by **subrat** » Mon Jun 30, 2008 11:27 pm

Hi,

Requirement: To get Sequence name(output) corresponding to Job name(input) through below routine.

$include DSINCLUDE JOBCONTROL.H

JobName=Arg1
JobHandle = DSAttachJob ("JobName", DSJ.DSJ.ERRFATAL)
controllerList=DSGetJobInfo(JobHandle, DSJ.STAGENAME)
ErrCode=DSDetachJob(JobHandle)
Ans=controllerList

But everytime i am executing it by passing a job name, it returning 0/-1 etc.... not the sequence name.

Please suggest me where i am wrong.

Thanks
Subrat

ArndW · Post by **ArndW** » Mon Jun 30, 2008 11:45 pm

Try

Code: Select all

controllerlist=DSGetJobInfo(JobHandle,DSJ.JOBCONTROLLER)

keshav0307 · Post by **keshav0307** » Mon Jun 30, 2008 11:51 pm

STAGENAME will not retun the sequence name.

if you can get the newest event id for and then this command

dsjob -logdetail <Project name> <job Name> <newest event id -4> <newest event id>|grep DSJobController

this will return the sequence of the job

subrat · Post by **subrat** » Mon Jun 30, 2008 11:54 pm

Thanks for the replay.

I used the " controllerList=DSGetJobInfo(JobHandle,DSJ.DSJobController)" as well but getting the same output (-1/0 etcc...)

Seeking ur suggestion

keshav0307 wrote:STAGENAME will not retun the sequence name.

if you can get the newest event id for and then this command

./dsjob -logdetail <Project name> <job Name> <newest event id -4> <newest event id>|grep DSJobController

this will return the sequence of the job

AmeyJoshi14 · Post by **AmeyJoshi14** » Tue Jul 01, 2008 12:11 am

keshav0307 wrote:STAGENAME will not retun the sequence name.

if you can get the newest event id for and then this command

dsjob -logdetail <Project name> <job Name> <newest event id -4> <newest event id>|grep DSJobController

this will return the sequence of the job

Hi Keshav,
One simple question.."grep DSJobController" will give all the jobs used in the a particular sequence..

Since i cannot test "logdetail" command ....that's why i am asking..

ArndW · Post by **ArndW** » Tue Jul 01, 2008 12:24 am

Are you passing in

"Jobname"

or the actual name of the job you want to find the controller for? Can you do a test and either print out or return the JobHandle variable value?

keshav0307 · Post by **keshav0307** » Tue Jul 01, 2008 12:27 am

the requirement is to get Sequence name corresponding to a Job

so you will passing a job name and get the sequence name where this job is called

ray.wurlod · Post by **ray.wurlod** » Tue Jul 01, 2008 12:31 am

JobName should not be quoted in DSAttachJob - this means that you are trying to attach a job that is actually called "JobName".

subrat · Post by **subrat** » Tue Jul 01, 2008 1:37 am

Thanks Ray. Now it is working....

I have one more question.. I have some 1000 DS Jobs.
I hav created a simple job where it will take these 1000 jobs in sequential file and in Transformaer of the job i have used the above routine to get the corresponding sequence which will be come in my output sequential file.

But when i am running this job i am getting the below error.

SEQTEST..Transformer_4 (fatal error from DSAttachJob): Job control fatal error (-12)
(DSOpenJob) Cannot open job DLY_Load_ABC_ABC040_Cust_OAT. - not a runnable job

This may be happening bcos some of the jobs are not compiled.. But anyhow i want my job should run and give me my desired output(sequence name)...

Please suggest..

Thanks
Subrat

ray.wurlod wrote:JobName should not be quoted in DSAttachJob - this means that you are trying to attach a job that is actually called "JobName". ...

ray.wurlod · Post by **ray.wurlod** » Tue Jul 01, 2008 5:43 am

You simply can not attach a job that is in a "not compiled" state.

skumar · Post by **skumar** » Thu Jul 03, 2008 3:56 am

Ray,

I am also having the same issue and i am able to get the output if both the job and sequence are in finished state.Can u please suggest me will it return the sequence name only with "Finished" state or "Compiled" state also???

Thanks in advance.....

Regards,
skumar.