How to Check old job log
Moderators: chulett, rschirm, roy
How to Check old job log
Since datastage only keeps log for a couple of days, is there anyway to go back & check the job log from a particular day in last month ?
Actually, it keeps logs for as far back as you allow it to. Don't forget you also have a Filter when you view that may be restricting you to only seeing the last few days. However, once logs have been purged (either automatically or manually) they are gone.
That is the primary reason so many people here are looking for ways to automate the extraction and archiving of log information into say, a relational database... and why Kim Duke is such a popular guy.
That is the primary reason so many people here are looking for ways to automate the extraction and archiving of log information into say, a relational database... and why Kim Duke is such a popular guy.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Not sure about the new console tools but the Director has a "Filter..." entry on the menu or you can press Ctrl-T to open up the Filter dialogue box. There are several different criteria available but the basic one is the number of entries to show - the last 100 lines, for example.
As to how many are stored, that would depend on if you have Auto Purge enabled. That can be set to only keep the last N days of log entries or the last N runs of a job. As noted before, however, once they are purged they are gone... as in gone gone.
As to how many are stored, that would depend on if you have Auto Purge enabled. That can be set to only keep the last N days of log entries or the last N runs of a job. As noted before, however, once they are purged they are gone... as in gone gone.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers