DSXchange

You seem a little confused about how to invoke multi-instance jobs. "StartJob", for example, is a constant. Also, the invocation ID follows, rather than precedes the job name. Best practice is to determine the sequence's invocation ID (probably in a routine activity) and pass that to the ...

I amy Sorry, i may not explained properly. Let me explain . I will get the list of jobs names to run for the day in a file. Ex: J1 J2 J3 I created a job design in Sequence to trigger the above jobs. Command Activity --> StartLoop --> TriggerRoutine --> EndLoop Here, TriggerRoutine will always trigge...

Hi All I need a help to pass Invocation ID at run time to a Sequence. What i am trying to do? I am triggering a SEQUENCE job (Multiple Instance) using Server Routine (TriggerRoutine). So that the SEQUENCE can trigger different jobs at the same time concurrently. My Loop Design Approach: GetJobsToRun...

Thanks Ray.

Hi craig Thanks for your reply. Sorry, I may not explain properly. I am trying to implement a logic in which i need to find the specified String "I will pass it as Param" is present in the file or not? Need is like X = cat filename | grep "MOON" SUN MOON EARTH If i write a code l...

Hi Which version of Datastage you are going to use? 8.1 will support only SQL Server 2005 and not 2008 8.5 will support only SQL Server 2008 , but not R2 In term of connection, you will not find any issues. But if you use Upsert, there you will start to face issue. Job may hang for hours even for fe...

Hi All I wish to search for a word in a file using BASIC language. I can open the file. Code: OpenSeq FILENAME To fOpened ReadSeq Record From fOpened But not sure how to search for a word inside the file. Sorry now only i started to work with BASIC Language. For example: SUN MOON EARTH I know what i...

Thanks Ray

But is the right approach what i am trying to do, refering to my previous comment?

Thanks
DS User

Hi Ray I totally agree with your point. In the present project, 1. Not decided to use any scheduling tool 2. Not decided to use Sequence 3. Every day will get a list of jobs to run (some day the list may vary) For example Job -------- Dependency Job Name A----------------No Dependency B-------------...

Hi James

Sorry. I got it. I check the syntax and came to know how it will work.

I do have one more question. I will post is soon.

Thanks a lot.

DS User

Hi James

Thanks for your guidance.

You asked to go for dsjob -run command to trigger from OS level. Am I right?

If so, how to run more than one job?

Please make me clear.

Sorry

DS User

Hi All If i get a list of independent job names; Is there is any way, where i can trigger the list of jobs at the same time. Example: Job List A B C Trigger A B C Notes: Not to use Sequence, becaue the job list may vary. I am in the plan to go for an approach like, create "N" number of bat...

Hi All, Right now I am working with DataStage on Windows and now the discussion started to find the difference between Datastage on UNIX vs DataStage on Windows? Is there is any valid reason to move Datastage 8x from Windows to Unix Windows Unix 1. Performance Yes / No Yes / No 2. Stability Yes / No...

Hi Ray

Thanks for your guidance. I will change my approach.

DS User

Hi Ray Thanks for your reply. Info: Hence i am getting help it should be good to have a Premium Ac. So just now subscribed my Premium Ac. But still my company is having Premium AC and i checked your reply. I checked the director of those specific jobs and it starts almost at the same time. So i unde...