Turn off Login messge for a specific user ??

[fnb4321]

   Does anyone know if there is a way to turn off the login message (30) for a specific user ?

I can't turn off globally through the system parameters because we run a script monthly to delete users who have not logged into OnDemand within the last 60 days.

However, I would like to turn off for a high volume service account because our System Logs are so large and I believe the excessive logins could be what is causing our intermittent problem with accumulation of arssockd processes that leads to slow response during peak periods.

[jeffs42885]

Here's a suggestion, perhaps disable logging globally..

I'm assuming in your query that you are using 30 records in your search?

Maybe replace that with not equal to 65 or 66, or something else of that nature that indicates that a user has not queryed anything or something like that?

[Justin Derrick]

I'd issue an SQL delete command nightly that removes the previous day's logins...  Something like "where msg_num = 30 and userid like 'User%'".  You'd want to run re-orgs a little more frequently to clean up the swiss-cheese-effect you're creating in the database pages though.