DSXchange

Search the forum for the Keyword "BCI".

I will always prefer to execute the sql statements, by using After SQL tab in the target stage.

OR you can write a job and call it through the after job subroutine, which will be simpler than calling sql statements from the routine.

We have a simple job with some 2 hashed File lookups. Our Job design is LKP1 LKP2 | | V V DRS --- IPC--TRANSFORMER --- IPC--DRS We are using DRS stage, because customers can configure it to run on any database. When testing this job, it is running perfectly when oracle is used as Source and target. ...

Your Search String "TableNm" is used some where in that job/Stage. Might be your job might be using Generated SQL, but the search string can be there in your User Defined SQL.

Eventually, the status of the Sequence Job should be Finished With Warnings, but in some cases , i have observed even though one job finishes with warnings, the Sequence job staus is Finished. For handling this, Enable "Automatically Handle Activities That Fail" in the job properties of th...

Did you tried using Pivot Stage?

Search the forum, with the keyword dsstpora.dll. It has been already discussed here.

No, as the trigger is set to OK, the second job wont be called if first job finished with warnings.

Please refer to this thread

How Job B is called from Job A, if you could say that clearly, you will get exact answer.

I hope the log file is corrupted, you can clear the log file , by executing the command, from the administrator command prompt.
This will clear the Auto Purge settings of that job, so please set it again.

Wrap all the lines together, (remove all enter characters) and make it as a single line and execute it.

Alternatively, you can can use this code in universe stage and get the desired output. Search the forum or read help, on how to use the universe stage

Welcome to DSXchange... Execute the following code in Administrator Command prompt, and you will get the desired results. select DS_JOBOBJECTS.OLETYPE AS STAGE_TYPE, DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L' from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE ...

I have generated the Sequence jobs, by writing a DS routine. My input will be list of jobs that needs to be there in the Sequence. First, i will loop through all of them, and get the required job parameters. and rest of the stuff in the Sequence job will be mostly hardcoded, except the Stage Positio...

Kim Duke has posted this query very long back SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'YOUR SEARCH STRING',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L' FROM DS_JOBS, DS_JOBOB...

From where we can see the DSD.RUN code?