Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Time last used/accessed/executed

3 posts in Product Futures Discussion Last posting was on 2002-02-04 17:35:54.0Z
TS Posted on 2002-02-04 17:27:13.0Z
From: "TS" <none@nowhere.at.all>
Subject: Time last used/accessed/executed
Date: Mon, 4 Feb 2002 18:27:13 +0100
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <7NiPsCarBHA.315@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: ip503cc813.speed.planet.nl 80.60.200.19
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:807
Article PK: 94335

I would like a feature that will allow me to determine when a database
object (table, stored proc, trigger, viw etc) was last accessed/executed.
Possibly a column in sysobjects?
It may be there already, but so far I have not found it.

Thomas.


Bret Halford Posted on 2002-02-04 17:33:31.0Z
Message-ID: <3C5EC5EB.223302FA@sybase.com>
Date: Mon, 04 Feb 2002 10:33:31 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Time last used/accessed/executed
References: <7NiPsCarBHA.315@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 9
NNTP-Posting-Host: 157.133.80.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:806
Article PK: 94332

Check out the auditing capabilities.

TS wrote:

> I would like a feature that will allow me to determine when a database
> object (table, stored proc, trigger, viw etc) was last accessed/executed.
> Possibly a column in sysobjects?
> It may be there already, but so far I have not found it.
>
> Thomas.


Bret Halford Posted on 2002-02-04 17:35:54.0Z
Message-ID: <3C5EC67A.A45CE3DA@sybase.com>
Date: Mon, 04 Feb 2002 10:35:54 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Time last used/accessed/executed
References: <7NiPsCarBHA.315@forums.sybase.com> <3C5EC5EB.223302FA@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 13
NNTP-Posting-Host: 157.133.80.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:805
Article PK: 94334

Chapter 12 of the ASE 12.5 System Administration Guide:
http://manuals.sybase.com:80/onlinebooks/group-as/asg1250e/sag

t Halford wrote:

> Check out the auditing capabilities.
>
> TS wrote:
>
> > I would like a feature that will allow me to determine when a database
> > object (table, stored proc, trigger, viw etc) was last accessed/executed.
> > Possibly a column in sysobjects?
> > It may be there already, but so far I have not found it.
> >
> > Thomas.