DSXchange

manual intervention is required for this, ie. manually taking the excel output and converting it into pdf...

My target is to prepare a pdf file report and send it to mail box of users using notification stage. so no manual intervention will be there...

its not a datastge report rather a Excel file with 10 columns which will be calculated in the Datastage jobs.

Its a report with 10 columns,

Hi,

is it possible in DS to create a PDF file. I have to create a pdf report using Datastage.

Rgds,
senthil

Am not sure whether there is any NLS setting for SQL Server DB, but the SQL Server DB has data stored in Czech Republic Language, my aim is to load the same Czech republican data into the Oracle DB through my Datastge Server job. I tried checking out the NLS setting of MS Sql Server DB, but not able...

Ok, Thanks for all your replies.

I have recreated the sequence with different name and ran, it works fine. I see with the same name of Sequence the Job is not running properly.

Thanks once again for your replies, Am marking this as Resolved now.

Yes, first some jobs in the sequence was set to Validate and then i change those to Reset if Require, Then Run, Compile Each and every Job and also the Sequence. After compiling and Running also the jobs are validating. I was able to resolve the issue as stated by one of the Replies from ArndW 'try ...

CTCTypeSeq..JobControl (@Coordinator): Summary of sequence run 04:25:34: Sequence started (checkpointing on) 04:25:34: Start_date (JOB EdwSQLStatement.EdwSqlStatements_EcomPricing_getLastRunDate) started 04:25:34: Start_date (JOB EdwSQLStatement.EdwSqlStatements_EcomPricing_getLastRunDate) finished,...

ray.wurlod wrote:

senthilmp wrote:Yes, am sure that i re compiled the sequence..

Even if you set the Job activities to "Validate" as the run mode the sequence will compile. Please answer Arnd's actual ques ...

The job activity set is having Reset If Require,then Run only.

Yes, am sure that i re compiled the sequence..

Hi,

i have sets of jobs being called through a sequence, in these sequence out of 10 jobs only 2 jobs are running fine and other jobs are just validating even if the execution action is Reset if Required, Then Run.

Pls help me out in order to resolve this issue.

Thanks in advance,
Senthil

Ok thanks, someone posted in the middle stating there is a propery and now its deleted, so only i asked about it.

Thanks for your support

YEs i use sequential file stage, but i dont see a property window to set the Mode specified....Where can i find the property in the Sequential file stage (My job is Server Edition)

Hi, My job uses a file as input, if the file is not present in the directory the job fails. I want the job not to fail if the file is not present in the directory. i.e The job should kick off only when the file is present else the job shouldnt kick off. I searched the forum but not able to locate co...

Thanks