Hi all,

I need to execute sp_sysmon on different versions of sybase. I would
like to know the syntax for executing sp_sysmon on various versions of
sybase.
For eg. the syntax on sybase12.5 is sp_sysmon 1(for monitoring 1 min)
somewhere it is sp_sysmon 00:01:00(i.e hh:mm:ss format).
could anyone please mail me the required format on various versions.

Thanks in advance.

Regards,
Amol

Amol Natekar wrote:
Have you checked out the Reference Manuals for the various versions of ASE
that you're running? You can find them at
http://sybooks.sybase.com/as.html.

Another alternative is to look at the source code of sp_sysmon (install
script or sp_helptext) and see what the format/datatypes are for the input
parameters.

--
Mark A. Parsons

Iron Horse, Inc.
iron_horse (AT) NOSPAM (DOT) compuserve.com

"Amol Natekar" <amol.natekar (AT) exact-solutions (DOT) com> wrote


Actually, it's the other way around: sp_sysmon 'hh:mm:ss' is the syntax
since ASE 11.5.
Until ASE 11.0, the syntax was sp_sysmon N, where N was a number between 1
and 10, indicating the number of minutes to wait.
The current sp_sysmon syntax (as well as all its other options) is quite
clearly documented, BTW. See the ASE docs at sybooks.sybase.com/as.html for
full details.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of various Sybase books. New book (coming soon): "The
Complete Sybase Replication Server Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------