In event detail section of Log info i can see the appropriate message. how can i capture this message on server jobs? I want to capture only the message.
-Nripendra
How to capture the message from Director Log?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
-
- Participant
- Posts: 82
- Joined: Wed Jul 14, 2004 7:21 am
- Location: India
I still do not get why people are doing all this in a routine. Write a job. Start with a UV stage. Output to a sequential file or a target table. I prefer the later. Here is the SQL for the UV stage.
I really think a lot of this is easier in jobs. All you need to do is write a batch job to feed the job names and job numbers into the parameters for JobName and JobNo. Just a few lines of code. You will need to create the target table.
Code: Select all
select EVAL "'#JobName#'" AS JOB_NAME, TIMESTAMP, SEVERITY, FULL.TEXT from RT_LOG#JobNo# where EVAL "@ID" NOT LIKE '//%' order by TIMESTAMP;
Mamu Kim