regarding command line utility

Saama · Post by **Saama** » Thu Dec 21, 2006 1:05 pm

hi gurus,

my job design is odbc---->transformer---->odbc
after compiling and running the job its stored in the repository.i use command line utility from administrator.
i have search for commands.
i have used LIST.DICT DS_JOBS, its displaying a list.
but my job name is saa, will this command display my job.
plz help me with the command that displays my job, regarding my metadata and transform components used.plz help me .

cheers;
saama

DSguru2B · Post by **DSguru2B** » Thu Dec 21, 2006 1:13 pm

LIST.DICT just displays the dictionary items not the contents. Plus DS_JOBS just has info about the jobs, not the stages. I say stick to DS functions to retrieve job meta data and stage info. Also, search for kduke's ETLStats.

chulett · Post by **chulett** » Thu Dec 21, 2006 1:13 pm

Why not just open the job in Designer and click the button that looks like an Internet Explorer icon? It will generate a lovely little HTML document will all that stuff in it for you... no charge.

chulett · Post by **chulett** » Thu Dec 21, 2006 1:14 pm

Again with the hard way, DS.

I_Server_Whale · Post by **I_Server_Whale** » Thu Dec 21, 2006 1:16 pm

You can just say :

Code: Select all


LIST DS_JOBS

to get a list of all of your jobs.

Or you can use:

Code: Select all


SELECT * FROM DS_JOBS WHERE NAME = 'YourJobName'

Searching the forum will get you many answers most of the times. I guess you didn't search before posting.

There are a lot posts for the search term 'LIST' or 'LIST DS_JOBS'. If you think your topic is resolved. Please mark it as resolved.

Whale.

DSguru2B · Post by **DSguru2B** » Thu Dec 21, 2006 1:17 pm

Ops, but not my fault, really, i got the impression that its something that the OP wanted to set up dynamically at a regular basis.

I_Server_Whale · Post by **I_Server_Whale** » Thu Dec 21, 2006 1:19 pm

chulett wrote:Why not just open the job in Designer and click the button that looks like an Internet Explorer icon? It will generate a lovely little HTML document will all that stuff in it for you... no charge.

This is the perfect answer for your needs.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 21, 2006 2:13 pm

It's an even better answer if you've been bothered to document your job design.

Axiom: there is never time to retrofit documentation.
Moral: do documentation first.

Saama · Post by **Saama** » Thu Dec 21, 2006 3:03 pm

Hi gurus,
Thanks very much.
i have used command line utility
SELECT * FROM DS_JOBS WHERE NAME='JOBNAME'
i also used another command, which i searched in the forum.
when i use SORT.ITEM DS_JOBOBJJECTS.
it displays record numbers.
how to identify my job when i use SORT command.
plz help me in identifying job.

cheers;
saama

ray.wurlod · Post by **ray.wurlod** » Thu Dec 21, 2006 3:08 pm

What are you trying to accomplish?
The join between DS_JOBS and DS_JOBOBJECTS is made as

Code: Select all

DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO

Saama · Post by **Saama** » Thu Dec 21, 2006 3:17 pm

Hi,
thanks guru.
i just wanted to view transformation used in the jobs from the command line utility, the metadata, the source table and target table used.

can we find these details of my job from command line utility.
my team lead wants to know that.
once again thanks.
my design is odbc---->transformer--->odbc.
thanks.

cheers;
saama

Saama · Post by **Saama** » Thu Dec 21, 2006 3:24 pm

Hi,
i have given command LIST DS_JOBOBJECTS.
how to find my object id.
there are many object id, plz help me how to find my object id.

cheers;
saama

chulett · Post by **chulett** » Thu Dec 21, 2006 3:42 pm

You find yourself at the top of a cliff. Before you are two paths to your objective at the bottom:

A) A long, winding, treacherous path known only to mountain goats and the Hill People who have lived here for centuries. Many have died attempting to take that route.

B) A shiny new express elevator.

You have chosen... A.

I_Server_Whale · Post by **I_Server_Whale** » Thu Dec 21, 2006 3:53 pm

chulett wrote:You find yourself at the top of a cliff. Before you are two paths to your objective at the bottom:

A) A long, winding, treacherous path known only to mountain goats and the Hill People who have lived here for centuries. Many have died attempting to take that route.

B) A shiny new express elevator.

You have chosen... A.

I mean real LOL...Uncontrollably.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 21, 2006 4:33 pm

How about you tell your team lead that the answer is "no"?

After all, SQL can not be executed directly from the command line, and the table definition of DS_JOBOBJECTS is made deliberately incomplete by the vendor.

But you might like to use the -report option with the dsjob command.

Code: Select all

dsjob -report [-useid] <project> <job|jobid> [report type>]

         report type = BASIC | DETAIL | XML