Query on DataStage Repository
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
Query on DataStage Repository
Hi
I need to query the DataStage repository to know the Job last run time and job status, for example,
Projecct_name job_name job_category job_lastrun_date, job_status
xxxx a temp\a 01/23/2011 finished
xxxx b temp\b 11/01/2009 compiled
I got Projecct_name job_name job_category
ie. SELECT NAME, JOBTYPE, CATEGORY FROM DS_JOBS;
but unable to get last two columns. please help me on this.
Thank you
venkat
I need to query the DataStage repository to know the Job last run time and job status, for example,
Projecct_name job_name job_category job_lastrun_date, job_status
xxxx a temp\a 01/23/2011 finished
xxxx b temp\b 11/01/2009 compiled
I got Projecct_name job_name job_category
ie. SELECT NAME, JOBTYPE, CATEGORY FROM DS_JOBS;
but unable to get last two columns. please help me on this.
Thank you
venkat
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why do you need to query the Repository? This information is available directly using the Director client.
It is a non-trivial exercise to query the Repository, because every job's status information is stored in a separate table.
It is a non-trivial exercise to query the Repository, because every job's status information is stored in a separate table.
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.
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
-
- Premium Member
- Posts: 4
- Joined: Tue Oct 19, 2010 6:29 am
chvenkat.v wrote:ok no problem
anyone can help me on this plz
Hi Venkat,
Chullett already explained how to do that...
Here in detail what Chullett said,
Go to director and switch off the categories (Folders) from View menu ,
Then all jobs will list out in one window..
Now go to project menu and select print , there you will see print to file option..
then save it as file then convert to excel..
--suri
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can get this from the internet, for example here
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.
What kind of "idea" are you looking for? If you don't have any shell scripting experience, it's not something someone can teach in a post or two. Do you have anyone you work with you could enlist to help you? You help them with the DataStage syntax, they do all the nasty scripty bits...chvenkat.v wrote:can please give me any idea about scripting.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers