DSXchange

You need to use a Custom trigger to handle this. For Ran Ok and Warnings, use something like this in the trigger to Job2: Job1.$JobStatus = 1 Or Job1.$JobStatus = 2 Note that 'Job1' in the above trigger code is actually the Job Activity stage name that runs Job1. I'd suggest using an 'Otherwise' tr...

I have a sequencer with a few jobs in it. What I want is Job1 should trigger Job2 when Job1 is either successful or has warnings. Job1 should not trigger Job2 only when Job1 fails. Job1 --------------> Job2 -------------------> | triggers Job2 when Job1 is successful or has warnings I will appreciat...

Job parameters provide insurance against things that can change over time (like passwords and selection criteria) and things that can be different on different environments (like DSNs, passwords, user IDs, schema names, pathnames). You should have made them into job parameters in the first place. M...

I am working on a project that uses Oracle as the database. The schema in the development is xxx. In the SQL statements in all the jobs, I have the follwing format: Select Cols from xxx.Tablename. Now the problem is we are ready to go to the QA and for whatever reason the schema name cannot be 'xxx'...

I have the following job design: In the main sequencer: I have a routine activity stage that determines the current date followed by a sub-sequencer. A job parameter in the sub-sequencer gets the current date from the routine activity stage as returnvalue. I also have other job parameters including ...

Ken, I did the way you suggested and it works. I did not have to use DSSetParam at all. I am wondering how that function works. If using batch control there is absolutely no problem in getting DSSetParam to work. However, if I am using sequencer then I would like to know if DSSetParam can be used at...

You absolutely cannot do this in a supported manner. You cannot change a job parameter value from within a the job itself during runtime. You must use a controlling job, such as a Batch or Sequencer, to set dynamic values at runtime. There are methods to change a parameter value during a jobs execu...

I have the following server routine running as Before-job subroutine. I have job parameter "FILE" that needs to be set in the routine. The default value in the job properties for the parameter is "XXXX". When I run the job I can see from the log that this subroutine is working an...

Thank you Craig. It is very clear to me now.

You can use DSSetUserStatus routine within your Basic function Hi Craig, Thanks for the help. I used DSSetUserStatus and it worked. But I would like to know your approach as well. In a server routine I don't know how to return the rowcount as ans . I believe I have to write a transform routine to b...

Sainath.Srinivasan wrote:You can use DSSetUserStatus routine within your Basic function

Thanks for the help. It worked.

From DSINCLUDE/JOBCONTROL.H Equ DSJE.BADLINK To -9 ;* LinkName does not refer to a known link of the stage Are you certain that the value passed from the Input Values field (to the InputArg argument) is correctly spelled and correctly cased? Even in your post you've been careless with case (DSgetLi...

I have after-job routine that works fine when I hard code the link name in the DSgetLinkInfo function. But when I am using the InputArg to pass the link name, I am getting -9 error.

Can anyone please help how I can fix this?

Thanks.

You need to change :1 into your category but here is the query. select EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '35L', 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 in ('CHashedOutput','CHashed...

I have a need to list all the hash files that are being created by all the jobs in one category. Then I need to some how determine which of these hash files are being used. I would appreciate if anyone can please suggest a better way to accomplish this. I was thinking of compiling the list of hash f...