DSXchange

Nope. Create the metadata first then use it. The act of 'loading' or dragging the metadata into the job itself is what creates the link the Usage Analysis tool needs.

DSer wrote:Can we save the metadata definitiona at a later stage and use this method?

Yes, using Save from a job design also establishes a linkage that Usage Analysis and other analyses can use. (However it does not save format information for sequential files.)

During the Save dialog be systematic about your categories - don't simply dump everything into the Saved category!

Thanks for the info.

So does it mean that we can get the usage analysis for jobs refering to a particular table,

before we have saved the metadata and after we have saved?

Or it it only moving forward, after the save is done?

Before you have saved, NO.
After you have saved, YES. Even for extant jobs.

Going forward, learn to Import then Load, rather than need to Save. You will make fewer mistakes in this way.

Hi,

I have a list of inactive jobs in the project.
I want to know the tables these jobs are using.
the tables may be source or target tables.
and the tables are teradata enterprise stages.

How do i get the list of tables in the project.

Thanks,
Samyam

I tried this but this query gives a lot of details.
I need only the table name and the DB name.

select EVAL DS_JOBOBJECTS."@RECORD<29>" from DS_JOBOBJECTS where DS_JOBOBJECTS.NAME ='JxZZEXT_TYP_FACT_ENCS_DECS';


Thanks,
Samyam

I think that question is far enough from the original topic of this thread to warrant your creating a new thread for it.

I have tried everything mentioned in the thread.
its not working. so you are saying there is no way to get it.

No, he's saying to stop hijacking this thread and create one of your own instead.

The SQL in

viewtopic.php?t=99543

Will find any string in a job. Use it and see if you cannot find all the jobs using a specific table.