Getting Sequencer name from the job name

[DSMaestro]

Hi Gurus,

I've a list of jobs in a sequential file.
I want to get the Sequencer name at which these list of jobs are being called.
How to achieve it by using Server routines...

Sample input & output are given below,

Input:

Job1
Job2
Job3
Job4

Output:

Job1 Seq1
Job1 Seq2
Job2 Seq1
Job3 Seq1
Job4 Seq1


Thanks in Advance...

[chulett]

There should be a Macro for that - and it will have 'Controller' in its name, from what I remember. Can't check right now or I'd post the exact name.

[ArndW]

The DSGetJobInfo(YourJobHandle,DSJ.JOBCONTROLLER) will give you a job's parent.

[DSMaestro]

The DSGetJobInfo(YourJobHandle,DSJ.JOBCONTROLLER) will give you a job's parent. ...

Thanks ArndW,

But how u call this function in server transformer....

[ArndW]

If you want the parent process of the job that is running, then simple use "DSGetJobInfo(DSJ.ME,DSJ.JOBCONTROLLER)"

[chulett]

Or, as noted, the DSJobController macro can be used just like a job parameter. Got a chance to look it up.

[DSMaestro]

Or, as noted, the DSJobController macro can be used just like a job parameter. Got a chance to look it up. ...

When i try placing this value in the column derivation of my tranformer
DSGetJobInfo(DSJ.ME,JobName)
I was getting -5 as output.
I was not getting the Sequencer name as output.

[DSMaestro]

Or, as noted, the DSJobController macro can be used just like a job parameter. Got a chance to look it up. ...

When i try placing this value in the column derivation of my tranformer
DSGetJobInfo(JobName,DSJ.JOBCONTROLLER)
I was getting -1 as output.
I was not getting the Sequencer name as output.

[chulett]

Did you try using the macro instead? Did you try looking up the error codes? They are documented.

[subrat]

Did you try using the macro instead? Did you try looking up the error codes? They are documented. ...

Could you try with the below macro and check if its working fine....

$include DSINCLUDE JOBCONTROL.H
JobName=Arg1
JobHandle = DSAttachJob (JobName, DSJ.ERRFATAL)
controllerList=DSGetJobInfo(JobHandle,DSJ.JOBCONTROLLER)
ErrCode=DSDetachJob(JobHandle);
print controllerList;
Ans=controllerList

Thanks
Subrat

[DSMaestro]

[quote="subrat]
Could you try with the below macro and check if its working fine....

$include DSINCLUDE JOBCONTROL.H
JobName=Arg1
JobHandle = DSAttachJob (JobName, DSJ.ERRFATAL)
controllerList=DSGetJobInfo(JobHandle,DSJ.JOBCONTROLLER)
ErrCode=DSDetachJob(JobHandle);
print controllerList;
Ans=controllerList

Thanks
Subrat[/quote]

Hi Subrat,

I'd included the code in a routine called GetJobStatus with one arguement Arg1.

When i run my job by calling this routine in my job by uisng the below derivation
"DSGetJobInfo(GetJobStatus(JobName), DSJobController)"

My job is getting aborted with the following error message

"ExtractJobDetails (fatal error from DSGetJobInfo): Job control fatal error (-1)
(DSGetJobInfo) Invalid job handle Seq_Name"

I see the sequencer name was getting retrieved correctly by the fatal error message,but why it was not getting return to the target & also why my job is getting aborted.

[subrat]

You are keeping all the job names in souce file? If yes try to put one comma (,) after each job name and then run your job.

Let me know if any luck.

[chulett]

DSGetJobInfo(GetJobStatus(JobName), DSJobController)

Your syntax is bad and you need to let the routine do all the work.

Code: Select all

GetJobStatus(JobName)

[ray.wurlod]

But how u call this function in server transformer....

Your original question was how to do it in a routine. People have been answering that question.

I doubt that U (one of our posters) is interested in calling this function at all, but I could be wrong. The second person personal pronoun in English is spelled "you". Please maintain a professional standard of written English on DSXchange; this helps those whose first language is not English.

The function name is DSGetJobInfo, not GetJobInfo. In a Transformer stage you would need to use a custom routine that is passed the job name that is being read from the file and which returns the list of controller job names.

[ray.wurlod]

Something like the following code would appear to meet the requirement.

Code: Select all

FUNCTION GetController(JobName)

$IFNDEF JOBCONTROL.H
$INCLUDE DSINCLUDE JOBCONTROL.H
$ENDIF

If UnAssigned(JobName) Or (Len(JobName) = 0)
Then
   Ans = @NULL
End
Else
   hJob = DSAttachJob(JobName, DSJ.ERRNONE)
   Controller = DSGetJobInfo(hJob, DSJ.JOBCONTROLLER)
   If Controller = DSJE.BADHANDLE
   Then
      ErrMsg = 'Unable to attach job ' : JobName
      Call DSLogWarn(ErrMsg, 'GetController')
      Ans = @NULL
   End
   Else
      Ans = Controller
   End
   ErrCode = DSDetachJob(hJob)
End
RETURN(Ans)