Hi,
I am looking for a better approach to solve this.
my job needs to test connectivity of databases . We have designed a job which would connect to a single database and runs a small query.
When our the parallel jobs completes we are writing the status a success to a report file and if the job Parallel job aborts we are writing status as failure. This runs in a loop for all databases.
My sequencer is restartable .
now my requirement is to add the fatal error message as part of the report file when ever the parallel job aborts.
what could be a best approach.
Thanks
RP
Capture Fatal error message
Moderators: chulett, rschirm, roy
The reject link coming out of your database connector can have the SQL code as a field, which you can then use to write to an error table.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Capture Fatal error message
Hi
You Can Write a Small Server routine using "DSRunJob" command which will fetch last run Job Status and based on status you can write Message in Status Report. This routine will be embeded in Loop it self only.
You Can Write a Small Server routine using "DSRunJob" command which will fetch last run Job Status and based on status you can write Message in Status Report. This routine will be embeded in Loop it self only.
-
- Participant
- Posts: 6
- Joined: Sun Jan 04, 2015 4:55 pm
-
- Participant
- Posts: 6
- Joined: Sun Jan 04, 2015 4:55 pm
I am new to Datastage and unable to write a routine in simple steps.
None of the links are giving a valid response on google.
I am not sure in which language/script the DS routines are written atleast to refer sample routines.
Someone gave a link to regularly used routines and the link is already expired.
I am not able to move ahead. Need some help
None of the links are giving a valid response on google.
I am not sure in which language/script the DS routines are written atleast to refer sample routines.
Someone gave a link to regularly used routines and the link is already expired.
I am not able to move ahead. Need some help
Thanks
RP
RP
DataStage routines are written in BASIC. From what I recall, all of the routines that ship with the product include their source code which you can examine as a great learning tool. Can you clarify for us exactly what 'fatal error message' you are after, is it in fact any from the job's log that you are after, the one you've said is to test connectivity?
If so, here's a couple of posts that may help:
viewtopic.php?t=151401
viewtopic.php?t=148423
There should be plenty of others, all I did to find these was an exact search here for "dsgetlog".
If so, here's a couple of posts that may help:
viewtopic.php?t=151401
viewtopic.php?t=148423
There should be plenty of others, all I did to find these was an exact search here for "dsgetlog".
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 6
- Joined: Sun Jan 04, 2015 4:55 pm