We use App Server to run mostly reports and a few screen processes at designated times each day. We do not use e-mails, or quick send, or anything else at this time.
Between 4 countries, we have roughly 170 jobs that run through App Server each day on 5 different App Server accounts. What we are finding is that our App Server Log table (AppSrvLog) is logging something every few seconds, even when jobs should be finished. It looks like we have some redundant entries and I'm not sure why these are happening. Below is an example of what is showing up in the tables:
App Server job for Post Transactions is set to run on the hour, every hour, daily.
3120699 30185 SAAPPSERVER 11/09/2013 12:00:31 AM 30185 Post Transactions Retrieved Request From Queue 0x00000000035BEB55
3120704 30185 SAAPPSERVER 11/09/2013 12:00:40 AM 30185 Post Transactions Request Started 0x00000000035BEB5C
3120707 30185 SAAPPSERVER 11/09/2013 12:00:49 AM 30185 Post Transactions End of Request 0x00000000035BEB62
3120714 30185 SAAPPSERVER 11/09/2013 12:01:01 AM 30185 Post Transactions Updating request status 0x00000000035BEB6B
3120718 30185 SAAPPSERVER 11/09/2013 12:01:10 AM 30185 Post Transactions Retrieved Request From Queue 0x00000000035BEB72
3120722 30185 SAAPPSERVER 11/09/2013 12:01:19 AM 30185 Post Transactions Request Started 0x00000000035BEB79
3120726 30185 SAAPPSERVER 11/09/2013 12:01:27 AM 30185 Post Transactions End of Request 0x00000000035BEB7E
3120732 30185 SAAPPSERVER 11/09/2013 12:01:38 AM 30185 Post Transactions Updating request status 0x00000000035BEB86
These requests continue in the same order from 12:01:38am for another 388 lines and go past 1:00am. Exactly the same 4 lines over and over and over again.
We expect to see at least 4 lines each time the job runs and when the job is completed, we believe this should sit idle until the next scheduled process starts. Is this incorrect?
Since the beginning of November we have logged 524904 records to this table and our table is becoming severely bloated. There is a process that we can see that runs a simple select * from AppSrvLog and it takes a very long time to load (we aren't sure what is calling it yet, but this seems to be happening all day).
I have checked the App Server settings for each account and cannot find anything regarding a summary or detail of logging types. Entries are set to be retained between 30 and 60 days before deleting old log files.
Is there some way that we can limit the amount of log entries into this table? Having almost 400 lines per job seems a bit excessive.
Any help is appreciated.
Thanks!
-Jenny