| Computers Forum Index » Computer - Databases - Sybase » Sybase log... |
|
Page 1 of 1 |
|
| Author |
Message |
| Subind... |
 Posted: Mon Sep 08, 2008 3:08 pm |
|
|
|
Guest
|
Hello All,
Is there a way to determine which stored proc / SQL ran on a given day
in Sybase?
Does Sybase maintain a log which have these information?
Thanks in advance,
Subind. |
|
|
| Back to top |
|
|
|
| Bret_Halford... |
| Posted: Mon Sep 08, 2008 3:38 pm |
|
|
|
Guest
|
On Sep 8, 9:08 am, Subind <subind... at (no spam) gmail.com> wrote:
Quote: Hello All,
Is there a way to determine which stored proc / SQL ran on a given day
in Sybase?
Does Sybase maintain a log which have these information?
Thanks in advance,
Subind.
Which of Sybase's database products are you asking about?
(Adaptive Server Enterprise? SQL Anywhere? IQ?)
If ASE, you can use the auditing feature to audit all cmdtext sent by
clients.
You can also use the mda monitoring table monSysSQLText if you
configure the
"max sql text monitored" configuration high enough to store a full
day's worth,
so arrange for a scheduled job to regularly flush the contents to more
permanent
storage. monSysStatement can give you exactly which stored
procedures ran and when. |
|
|
| Back to top |
|
|
|
| Marcin Najs... |
| Posted: Fri Sep 12, 2008 5:01 pm |
|
|
|
Guest
|
Subind pisze:
Quote: Hello All,
Is there a way to determine which stored proc / SQL ran on a given day
in Sybase?
Does Sybase maintain a log which have these information?
Thanks in advance,
Subind.
Hi,
You can turn on Auditing for ASE (or you can use MDA tables)
More details: http://infocenter.sybase.com
Regards,
--
Marcin Najs |
|
|
| Back to top |
|
|
|
|
