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]'
veera24 - The SQL that ag_ram gave you is (a) incorrect and (b) uses undocumented tables in the product as well as the TCL command line.
It is simpler and better to get the job number by running the job, then looking at your first director log file entry and getting the name from there.
It is simpler and better to get the job number by running the job, then looking at your first director log file entry and getting the name from there.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Craig, don't worry, it is just that Prof. ag_ram has put his seal of approval on your answer.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Lovely.
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.
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
I have cross-checked on AIX and Solaris and the jobno is there - so it would seem to be specific. I assume that the object directory is added because it is required, so I am surprised that HP-UX doesn't have it. Perhaps the addition is an artefact that will disappear at some future release.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Craig - that would make a lot of sense, since I never noticed that path before with server jobs.... yep, you are correct, I just checked a job sequence and it didn't modify any of the search rules.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>