DSXchange

Following image is for Job Activity:-


Following image is for Rotine Activity:-

chulett wrote:And "Stage Name from PX job" means a hard-coded value or something derived?

Yes Craig, The Stage Name and Link Name are hard-coded. But job name is not hard-coded, it just pass through activity variable.

How can I attach snap-shot with this post?

As noted, the job name requires the invocation id but the stage and link name do not. Correct your call. That's Correct.We are doing same way. Job Design :- ...Job_Activity ---> Routine_Activity .... Routine Code:- $INCLUDE DSINCLUDE JOBCONTROL.H Ans = 0 handleJob = DSAttachJob(extractJobName, DSJ....

I tried printing the stagename in Email subject & it gives me Jobname.InvocationId.

#JA_Company_Loaded_Staging_Job.$JobName#
returned - Company_Loaded_Staging_Job.TestInvocation_Seq

ray.wurlod wrote:Are you attaching the correct instance when invoking DSGetLinkInfo() ?

We are passing StageName.$JobName (Stage Name of Job Activity which calling Multi Instance PX Job)

Hi Ray, I have an example below which explains the issue. Check_If_Already_Run_Job - Multi instance job which checks if the process is completed for today. Abc_Seq - Sequence invoking above job. Based on a requirement we run this sequence for a period ex: 3:00pm - 7:00pm every 15 mins. Multi instanc...

In sqlserver target, how to commit records all at once (single commit)

Thanks in Advance

I have a job in which stored procedure will be called and output of stored proc will be sent to further process. Stored Proc will take 2 arguments as input and provides the output in 2 arguments. Input arg : startdate and enddate Output are : ABC and XYZ. Please let me know which stage (STP or ODBC)...

Hi All, We are using DSGetLinkInfo (with 4th option as DSJ.LINKROWCOUNT) to get row count of the link of PX job once job is finished successfully. But we encountered a situation in which it is returning wrong value (for ex. it is giving row count = 0 instead of 1). I did search on the different foru...

Yes you are right..If I pass the same date values in a Server job and use ICONV & OCONV functions as mentioned in my previous message, it seems to be intelligently converting 96 to 1996 and 08 to 2008. This is precisely my question, how is it working correctly in Server? I have not done any Env ...

My question is..the dates mentioned in my previos message are translated correctly in Server where as in PX using the Env Variable, it traslates the Centruy part incorrectly..always add "20" to the YY part and makes it YYYY e.g 96 comes 2096 and 08 becomes 2008 in PX where as in server it ...

My question is..the dates mentioned in my previos message are translated correctly in Server where as in PX using the Env Variable, it traslates the Centruy part incorrectly..always add "20" to the YY part and makes it YYYY e.g 96 comes 2096 and 08 becomes 2008 in PX where as in server it ...

Hi, In PX, using the Env Variable for APT_DATE_CENTURY_BREAK_YEAR with values 2000 will ensure that all YY will be converted to 20YY or using the format %2000yy will do the same. But if we have dates like 20-AUG-96 and 10-SEP-08 both will be converted to 20-AUG-2096 and 10-SEP-2008 , which is wrong ...

Hi Ray, We have been using the same job with different invocation id's, Few of invocations are running successfully and few of them are throwing warning like "expecting 4 segments, read 6 segments." When we view the dataset management utility it is showing like below message Exception_745 ...

ray,

we used hash and same partition earlier but same issue happening