DSXchange

Hello All,

Which is the easiest way to search for a specific job in a project when you have 50 to 80 categories and more than 400 to 500 jobs.

thanks

Thanks to those from whom I learnt

1. SELECT JOBNO from DS_JOBS WHERE NAME='jobname'

from your administrator command GUI or datastage shell

This would ensure that the job is present in repository.


2. dsjob -ljobs projectname>filenamewithpath
//writes all your jobs in

This would write all your jobs in a file.

Do # grep jobname filenamewithpath

ensures that job is present in the project


hope that helps

Either from the command window in Administrator or TCL you can enter the following command -
Or if you are not sure of the name or want to expand the search you could do -

Acutally you can also do it in Director using the filter. I use this frequently.

Larry

Director also has a search capability (the tool with the binoculars). You can, from the View menu, disable categories, and get all jobs in one large list; the search capability is then guaranteed to find your job (if it exists).