DSXchange

This is restricted to be used by dsadm user, Is there not a user/developer way to achieve this?

I am trying to find out the counts on each link of all my jobs in a particular project. I have the job names with me.

I am using one shell script that sequentially uses -lstages, -llinks and -linkinfo option of dsjob command. The number of links returned by -llinks option are double than what actually is there in the job which is pretty obvious because one link is input for one stage and output for other one. For t...

Cannot see the entire content, But Yes I am getting data out of DS_JOBS accurately. I would like to incorporate my other post in this only: Firstly, I am querying DS_JOBS and DS_JOBOBJECTS(using CJobdefn as filter), the Count of 2 doesn't match. Secondly, If I join the 2 tables on JOBNO and OBJIDNO,...

Is there any other way to find out the last compile time of the job? Example: DS_JOBJECTS does provide things under its @RECORD<X,1> variable where X and Y has a wide range (1,1.. 26,1) I couldn't see your content, am working with my organization for premium membership but need to work like this til...

Ray: Does that works well for DS11.3? I used this query but it does not get the most recent results.

I had some jobs that were compiled yesterday (13-July) but this query got me the last timestamp as 31-05-17 which would probably the previous compile time of the job.

If this does not lists all my jobs (which currently is happening with me), then where should I ask my admin to look into.

I know it should, but it is not, I'll close the post after your reply.

You need to join DS_JOBS.JOBNO to DS_JOBOBJECTS.OBJIDNO, not to OBJID ... Apologies, I was joining on OBJIDNO itself and still not getting the entire list of jobs. Could the reason be the Update that I made to the post i.e. select NAME,DS_JOBOBJECTS.OLETYPE,DS_JOBOBJECTS.OBJIDNO, EVAL DS_JOBOBJECTS...

am trying to join DS_JOBS and DS_JobOBJECTS table on JOBNO and OBJID respectively. One of my environment is not yielding the correct number of jobs that it ideally should and the reason is the JOBNO and OBJID are not having the same values. In Dev I am getting 2500 jobs but in Test I am only getting...