Job Number
Moderators: chulett, rschirm, roy
Job Number
hi all,
Could any one tell me that where shall i get the job number of a particular job when it runs successfully?
Your time ll be appreciated..
Thanks in advance
veera...
Could any one tell me that where shall i get the job number of a particular job when it runs successfully?
Your time ll be appreciated..
Thanks in advance
veera...
chulett - I do pose a query regarding your statement, though which seems to be offtopic.
Please clarify this.
I am very keen to have a clarification for this statement. What causes the Job no changed over the lifetime of Job and how it happens internally?chulett wrote:...which can change over the lifetime of the job.
Please clarify this.
Correct chulett.
The Job no of a particular Job is changed only when the Job which has same Job name, gets imported into that project.
Author - you may use this SQL
The Job no of a particular Job is changed only when the Job which has same Job name, gets imported into that project.
Author - you may use this SQL
Code: Select all
SELECT JOBNO FROM DS_JOBS WHERE NAME like '%[i]Jobname[/i]'
ArndW,
1. Would you like to let me correct myself the SQL i gave if i just intended to italic the job name in the code section.
2. Did you note that chulett has also recommended that way? Was he also wrong recommending to use undocumented tables?
3. Would you like to advise me where to look at Job no in the director log entries.
Please clarify this.
1. Would you like to let me correct myself the SQL i gave if i just intended to italic the job name in the code section.
2. Did you note that chulett has also recommended that way? Was he also wrong recommending to use undocumented tables?
3. Would you like to advise me where to look at Job no in the director log entries.
Please clarify this.
ag_ram - I didn't state that either Craig or yourself were wrong, just that using documented methods is preferred over undocumented ones.
veera24 - I neglected to finished the details in my original post. Open up the 3rd log entry, where the ENVironment is displayed, and the LD_LIBRARY_PATH will have the jobno as the first entry.
veera24 - I neglected to finished the details in my original post. Open up the 3rd log entry, where the ENVironment is displayed, and the LD_LIBRARY_PATH will have the jobno as the first entry.
Lovely.
![Confused :?](./images/smilies/icon_confused.gif)
Edited to add: I had also checked to see if there was a Macro for this, but didn't see one. So the DS_JOBS query is the only mechanism I am aware of to get this information.
Still curious why the original post was phrased the way it was.
Arnd, I looked for something in the logs that would denote the job number before I posted, in case there was something there. I still don't see it as HP-UX doesn't use LD_LIBRARY_PATH and the SHLIB_PATH entry in my jobs doesn't have the job number in it anywhere that I've noticed. So is this something OS specific?ArndW wrote:veera24 - I neglected to finished the details in my original post. Open up the 3rd log entry, where the ENVironment is displayed, and the LD_LIBRARY_PATH will have the jobno as the first entry.
![Confused :?](./images/smilies/icon_confused.gif)
Edited to add: I had also checked to see if there was a Macro for this, but didn't see one. So the DS_JOBS query is the only mechanism I am aware of to get this information.
Still curious why the original post was phrased the way it was.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers