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
Search for a job
Moderators: chulett, rschirm, roy
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
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 -
Code: Select all
LIST DS_JOBS = {your_job_name} CATEGORY
Code: Select all
LIST DS_JOBS LIKE ...{partial job name}... CATEGORY
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.