Search for a job

[rcil]

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

[bryan]

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

[mhester]

Either from the command window in Administrator or TCL you can enter the following command -

Code: Select all

LIST DS_JOBS = {your_job_name} CATEGORY

Or if you are not sure of the name or want to expand the search you could do -

Code: Select all

LIST DS_JOBS LIKE ...{partial job name}... CATEGORY

[lebos]

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

Larry

[ray.wurlod]

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).