How to find the path of the job?

sureshchandra · Post by **sureshchandra** » Thu Mar 06, 2008 12:58 am

Hi,
Can any one help me in finding a path of the server job.My job is stored in a FTP server say X.How to find the path of that particular job stored in FTP server?

tombastian · Post by **tombastian** » Thu Mar 06, 2008 1:28 am

In the Administrator -> Command prompt execute the following: SELECT * FROM DS_JOBS WHERE NAME='<Job Name>'

This will list the category where the job is available.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 06, 2008 2:13 am

A job does not have a path. It is a set of objects stored in a database called the Repository - there is a separate Repository for each project in versions earlier than 8.0. DataStage server jobs are executed in a "virtual machine" called the DataStage Engine by a DataStage program called DSD.RUN, which reads appropriate entries from that database to execute what was designed. It usually starts child processes, especially for jobs that contain Transformer stages.

sureshchandra · Post by **sureshchandra** » Thu Mar 06, 2008 2:45 am

Hi,
Thanks for your response.I'm working on deployment.I test the jobs in QA server(Testing server).Jobs are successful.
I want to login to the ftp sever and check if the data files successfully loaded are not.
For that i have to know the name of the output files being FTPed.
Where and how can I find this parameter values?

Thanks in advance

ArndW · Post by **ArndW** » Thu Mar 06, 2008 2:59 am

The only way to transfer jobs between projects (regardless of what server they are on) is via the DataStage export/import methods. This export file, either in .dsx native format or as .xml, can then be ftp'd.

Or are you looking at the data files used in DataStage?

sureshchandra · Post by **sureshchandra** » Thu Mar 06, 2008 3:18 am

Hi Arndw,
I'm checking datafiles in FTP server. I need to search the output file name from the job.

ArndW · Post by **ArndW** » Thu Mar 06, 2008 3:26 am

Normally the paths used for files are runtime parameters so you can look it up in the log files, or use the dsjob command and a shell script to parse the path out.

sureshchandra · Post by **sureshchandra** » Thu Mar 06, 2008 3:28 am

Hi Arndw,
I'm checking datafiles in FTP server. I need to search the output file name from the job.

sureshchandra · Post by **sureshchandra** » Thu Mar 06, 2008 3:32 am

Hi AndreW'
Thanks for ur reply

ray.wurlod · Post by **ray.wurlod** » Thu Mar 06, 2008 4:32 am

You need to know the output file name. Then you can search for it. Typically at least the file's directory will be a job parameter, so its location is indeterminate by inspecting the DataStage design. You need to consult the Director client (or job log via dsjob command) to determine with what parameter values the job was run.

sureshchandra · Post by **sureshchandra** » Thu Mar 06, 2008 4:56 am

Hi Ray,
Where to search for that output file name?
In Log folder available in the testing server.

sureshchandra · Post by **sureshchandra** » Thu Mar 06, 2008 4:58 am

Hi Ray,
Where to search for that output file name?
In Log folder available in the testing server.Can u be clear

thanks in advance

ArndW · Post by **ArndW** » Thu Mar 06, 2008 4:59 am

It is very hard to understand your requirements. The output file(s) are defined in the jobs and only you have access to those.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 06, 2008 6:04 am

There is no log folder. Each job log is a table in the Repository database. It can be accessed via the Director client or via the dsjob command.

I think you would be wise to consider enrolling in a DataStage Essentials class.

sureshchandra · Post by **sureshchandra** » Thu Mar 06, 2008 6:37 am

Hi ray,
I'm discussing about the adminstration work not devlopers.
In testing server under the batch job there will be some sub folders.
like hash,ftp,log etc....