how to locate a job in the repository
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 45
- Joined: Tue Aug 29, 2006 2:59 am
- Location: Bangalore
how to locate a job in the repository
Hi All,
I have around 5000 jobs in my project.
How do I find out / locate a job ?
I dont have the category structure in which it lies.
Jus hava the job name.
Do we have any such way?
(something like ctrl+f that we use for text doc)
Please let me know.
Thanks in advance.
I have around 5000 jobs in my project.
How do I find out / locate a job ?
I dont have the category structure in which it lies.
Jus hava the job name.
Do we have any such way?
(something like ctrl+f that we use for text doc)
Please let me know.
Thanks in advance.
You can locate it by using this command in the DS administrator -
Search for alternate ways.
Code: Select all
SELECT NAME, CATEGORY FROM DS_JOBS WHERE NAME = 'JOB_NAME' ;
Last edited by narasimha on Tue Mar 06, 2007 10:17 am, edited 1 time in total.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
narasimha, I think the OP is concerned more in finding the job in the designer in order to open/edit/run it. Analogous to finding a link on a website with 5000 links. A simple find and click. Unfortunately such a thing is not present in DataStage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Re: how to locate a job in the repository
Use a UV stage with the user-defined SQL -
This will list each job with its category. You may order it by Jobname.
gateleys
Code: Select all
SELECT DS_JOBS.NAME, DS_JOBS.CATEGORY FROM DS_JOBS WHERE DS_JOBS.NAME = <Your_Job_Name>;
gateleys
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Found another way -
In DS Director -> View -> Filter Entries
You have options to include or exclude Job names, works with the wild character '*'
You need to disable the category View though.
(Ray, Thanks for pointing in the right direction)
In DS Director -> View -> Filter Entries
You have options to include or exclude Job names, works with the wild character '*'
You need to disable the category View though.
(Ray, Thanks for pointing in the right direction)
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Premium Member
- Posts: 45
- Joined: Tue Aug 29, 2006 2:59 am
- Location: Bangalore