DSXchange

Hi, In order kill any job.. you have give PID(process_id).. when any job or sequence is started is initiates a new process in Unix.. when the job is started you can see the job name with the processid.. if you want to kill or stop a job that is running(it is not advisable not kill through unix promp...

Hi Ashwin, In order any Datastage job through Unix command line.. you have to give dsjob command from the Datastage bin directory..for example.. $BIN_DIR/dsjob \ -run \ -warn 1 \ -param <give any parameter here> \ -jobstatus \ $project \ $JOB you have to pass the job name or sequence name along with...

Rubu,

As you are saying that you are able to open the project from another machine.. there could some problem or corruption with the Datastage Client installed in your machine.. have you tried uninstalling and installing the client in this machine?...

Regards
Sudharsanan

Andal,

Can you provide some more information about the job.. what are actually doing in that job..please provide some inforamtion so that we can think of the reason...

Regards
Sudharsanan

Tom, "it worked...but not before some anxious movements.. " what are the anxious movements you did?.. Kriti, can you throw some inputs on Re-indexing... why this has to be done?.. and what are the advantages and Disadvantages of Re-indexing?..please let us know... Thanks Sudharsanan AN

Hi, I am facing a similar kind of issues..as you have said in the post "The contents to be looked up (reference data) put it into a hash file, make from and till as the keys. In another job access this hash file using a universe stage as the universe stage allows you to query on the hash file j...

Thanks to everyone the issue got resolved.. there was two calls to DSSendMail routinue, i modified in only one place..that why i was getting the warning.. Sorry for the confusion...Thanks

Hi, The following are the values that i give to the DSSendMailTester 1.ToAddress -'xx@abc.com' 2.FromAddress -'xx@abc.com' 3.Subject--'Hai this is a test mail' 4.SMTPServer-'11.1.4.45'-- My SMTP Server IP Address 5.MessageBody-'Body:JobHashedCompleted\n%report%'--- I don't think that there is an ( o...

Thanks to Ray,Smith and other for helping me..but unfortunately i am getting the same issue, now i gave quotes to all the field in DSSendMailTester routinue, my job got compiled successfully...but when i run the job i getting the same exception again " SeqLoadHash..JobControl (DSSendMail): Para...

chulett,

I have seen the post given by Ray in December 2003..he has given the reason for this problem.. I am clear with that, i just want to give soem examples about some other warnings that i used to get in director...

Thanks..

No problem Chulett... I am using sequence jobs in my design.. I will try to use the Notification stage in my job..and use that option to send a mail and i will give the results to everyone...

Thanks

Thanks chulett, i will try to use the "Either use two triggers - one Ran Ok and one Ran with Warnings - run them into a Sequencer set to 'Any' and then on to the next job" option in my sequence so that i can get rid of this warning messages...this will also be useful all my jobs.. because ...

I am not compiling the routine i am compiling the my job.. that time only i am getting this problem.. i don't know much about the notification stage...can you give some more info on this stage?. so that i can try this.. my requirement is to send a mail when a particular job is completed.. so it can ...

Roy, I tried that routine also it asks for all the values like from,to,body,SMTP Server.. i gave all the values but when i tried to complie the job i get the following error.. Compiling: Source = 'RT_BP5160/JOB.2017379336.DT.1354017781', Object = 'RT_BP5160.O/JOB.2017379336.DT.1354017781' **********...

Thanks Phani for the input.. i tried that option it is working fine.. i have one more question if suppose i have more than two constraints in output which one i have to use for reject...is this the correct method to use.. does anybody has some other logic to avoid the warning of reject records.. ple...