DSXchange

Now since i am running the job through Sequence, i don't have control to set the job limit. Sure you do... or at least you should. If you run the Sequence job itself with a Warning Limit of 1 it should pass that limit to all child jobs it runs automatically. As noted, it's supposed to be as easy as...

thumsup9 wrote:In the first job activity use Warning _ Conditional as Trigger and send this link to Routine Avtivity where you can call routine rtLogFatal.

or you can set Warning Limit to 1 in the Job Run Properties of Director.

Thanks thumsup9.

This does not help.

Let me ask you one more question. When you say the Job1 aborts as soon as it logs its first warning, do you mean as soon as it encounters any rejects or is it just any other warning. If you can explain about this, may be we can have a solution in hand. If i run the job individually, i can set the j...

narasimha wrote:Give this a try

Set the Trigger on JOB1 as OK - (Conditional), this way if JOB1 gets even 1 warning, it will abort the sequence.

Thanks Narasimha.

NO, this did not work.

IMO it's not possible to abort the sequence as soon as any Job logs the first warning message. You can abort the sequence when any job finishes with warnings. In other words, i would like to set the job limit to " Abort after 1 warning ", for all the jobs in the Sequence. How do i do that...

Hi All, I have 5 jobs running through the Sequence , one after the other. I would like the Sequence to abort as soon as JOB1 logs 1 warning message (MetaData mismatch error/Data truncation error). How should I do this in Sequence? I have done this in JobControl by using DSSetJobLimit & DSGetJobI...

Hi All, From the DataStage Manager, I am trying to delete whole CATEGORY from TableDefintions ( TableDefinitions\Sequential\txt ), but i could not. There were no TableDefinitions in that CATEGORY. When i say DELETE, it does nothing. what might be thereason? If i want to do it from DataStage Administ...

Hi All, For searching a particular string in SYSTEM TABLES , currently i am using this query (i think KimDuke posted this query some time 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(...

Few of my jobs got aborted after 50 warning logged. Can you please let me know how to remove this setting. As noted, you will be much better off if you fix your jobs so they don't generate warnings. IMHO, there's no reason under the sun why Server jobs should ever generate warnings, let alone enoug...

Hi All, Currently we are on DataStage Server Edition 7.5.1A running on Windows 2000. We are looking forward to upgrade to Enterprise Edition of Hawk, after the Hawk release. Can we still run existing ServerJobs in EnterpriseEdition without any changes? Is it mandatory to make all ServerJobs as Share...

Hi All, We are currently working on a Enterprise Warehouse strategy, to be submitted to the client. Can any one have, any document which compares the top ETL tools. Also any graphical chart which shows where IBM DataStage stands in the market among all the ETL tools. That would be very helpful. Than...

Regarding the use of multiple projects, I understand that some company's have put as many as 9000 jobs in a single project with a limit of 5000 in Unix. I've also been told they've used as many as 80 projects. (Limit of 75 on Unix) Based on these stats, technical constraints with having many project...

Again, don't compile/run/test things in the VC project as it will just cause you grief because every object is renamed there. Your first error message implies that the routine that was 'never dimension' has never been promoted to your Production project. Promote it again, even if you think it's alr...

That too. Compile in development. Test in test. Promote with Version Control. I am sorry for not providing the full details. We Initialized the Jobs & Routines(6 months back) from DevelopmentProject to VersionProject. The same Jobs & Routines were Promoted to Production project. Now we are ...

Hi All, All of a sudden all my routines in VersionControl are failing compilation: TEST #1 ******* Arg1 = ste!ve Failed to compile test harness Compiling: Source = 'DSU_BP/TSTValidateName^^1_1.B', Object = 'DSU_BP.O/TSTValidateName^^1_1.B' 0001 DEFFUN ValidateName^1_1(Arg1) CALLING "DSU.Validat...