search a job name

[vsi]

A simple question - Is there a way to search a job by its name.

I am trying to save a job by particular name and it says the job name already exists. I am trying to find the already existing job, already spent lot of time on it and yet unable to find the job.

Is there a way to search Job Name, just like FIND in MSOffice.

-Thanks

[Krazykoolrohit]

NO. there is no such find functionality.

In case you need a workaround. goto manager and choose tools->export.

in the popup that appears you will get a drop down of all jobs alphabetically listed with category.

hope that helps

[vsi]

Thank you, that was good one :D . But, strangely the job doesnt exists at all, still it says the job already exists when i try to save by that name? I remember vaguely that I have once created that name.

Any Ideas on this behavior of datastage even when the job doesnt exists??

[narasimha]

Go to DataStage Administrator and execute this in the command, you will gets the job's location

Code: Select all

select * from DS_JOBS where NAME = '<JobName>'

[DeepakCorning]

VSI ,


I do not know about UNIX but it is very much possible in Windows.
Go to Ascential Admin and from there to command Type the follwing query --

Select * from DS_JOBS WHERE NAME LIKE "%<JOB_NAME>%.

[kris007]

It doesn't have anything to do with Unix or Windows. Just use the above statement in the Administrator and you will get what you need.

[ray.wurlod]

Open Director in Status view and unselect Show Categories in the View menu. Next time the Director refreshes it will show all jobs, sorted by name, in the one window. The category is in an adjacent column in the grid.

Note that if you sort by Status (click in the grid header to sort) you have a quick mechanism to find all Running jobs, all Aborted jobs, and so on (not all status possibilities are covered in the Filter).

Re-enable Show Categories so that Director refresh does not consume too many resources.

[Luciana]

Go to DataStage Administrator and execute this in the command:

select * from DS_JOBS where NAME = 'Arquivo'

Return:
Job name .... Arquivo
Description..
No.............. 55
Category..... Testes

If you don't visualize it in DataStage Manager, you can delete all references of the job with the commands below:

DELETE.FILE DATA RT_CONFIG55
DELETE VOC RT_CONFIG55
DELETE VOC RT_STATUS55
DELETE VOC RT_LOG55
DELETE VOC RT_BP55
DELETE VOC RT_BP55.O
DELETE VOC DS_TEMP55
DELETE VOC RT_SC55
DELETE DS_JOBS Arquivo
SELECT JOBNO, NAME FROM DS_JOBS WHERE NAME = 'Arquivo'
LIST DS_JOBS WITH JOBNO=55

The two last commands return: 0 records listed.

If you need of the job, then try to use the command DS.REINDEX ALL in DataStage Administrator, but make backup of the project before. The problem can be in the index of DataStage.[/code]

[ray.wurlod]

Not enough!

Before removing the DS_JOBS entry you will need to remove all its children from DS_JOBOBJECTS.

Code: Select all

DELETE FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = 'Arquivo');

Warning
Any damage you inflict upon Repository tables is not covered by warranty. Make sure you have good backups, in case you make an error.