Hi ETLers,
Sinario is: i want to load the ds-job log(warnings) into a oracle table.
can anyone suggest how to achive this?
Redirectly job log to oracle db tables
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
Then you're not searching the right search as there are tons of posts on extracting the log information and shoving it into another hiding place. They may not all deal specifically with just 'warnings' but the information is out there. I'm assuming the 'get out' part is the issue, not the 'put into Oracle' part.
For a routine-based solution, search for the various 'DSGetLog' functions:
DSGetLogSummary
DSGetLogEntry
DSGetNewestLogId
For a scripted solution, there are equivalents to all of these in dsjob which a search would also turn up:
dsjob -logsum
dsjob -logdetail
dsjob -lognewest
The former are in the online help, the latter in either of the Developer's Guides in the Command Line Interface chapter.
For a routine-based solution, search for the various 'DSGetLog' functions:
DSGetLogSummary
DSGetLogEntry
DSGetNewestLogId
For a scripted solution, there are equivalents to all of these in dsjob which a search would also turn up:
dsjob -logsum
dsjob -logdetail
dsjob -lognewest
The former are in the online help, the latter in either of the Developer's Guides in the Command Line Interface chapter.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: