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.

how do you figure out when a proc was last executed?

6 posts in General Discussion Last posting was on 2009-08-04 12:09:15.0Z
vtpcnk Posted on 2009-08-03 16:02:42.0Z
Sender: 1a50.4a69f79f.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.ase.general
Subject: how do you figure out when a proc was last executed?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a770a22.2e24.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 3 Aug 2009 09:02:42 -0700
X-Trace: forums-3-dub.sybase.com 1249315362 10.22.241.188 (3 Aug 2009 09:02:42 -0700)
X-Original-Trace: 3 Aug 2009 09:02:42 -0700, forums-3-dub.sybase.com
Lines: 2
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28087
Article PK: 77332

any ideas?


Sherlock, Kevin [TeamSybase] Posted on 2009-08-03 16:10:58.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4a770a22.2e24.1681692777@sybase.com>
Subject: Re: how do you figure out when a proc was last executed?
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a770c12$2@forums-3-dub.sybase.com>
Date: 3 Aug 2009 09:10:58 -0700
X-Trace: forums-3-dub.sybase.com 1249315858 10.22.241.152 (3 Aug 2009 09:10:58 -0700)
X-Original-Trace: 3 Aug 2009 09:10:58 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28088
Article PK: 77333

MDA tables, Auditing, Historical server, probably lots of others. Have you
looked at any of these options?

<vtpcnk> wrote in message news:4a770a22.2e24.1681692777@sybase.com...
> any ideas?


vtpcnk Posted on 2009-08-03 16:14:26.0Z
Sender: 2f94.4a770c03.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.ase.general
Subject: Re: how do you figure out when a proc was last executed?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a770ce2.303a.1681692777@sybase.com>
References: <4a770c12$2@forums-3-dub.sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 3 Aug 2009 09:14:26 -0700
X-Trace: forums-3-dub.sybase.com 1249316066 10.22.241.188 (3 Aug 2009 09:14:26 -0700)
X-Original-Trace: 3 Aug 2009 09:14:26 -0700, forums-3-dub.sybase.com
Lines: 4
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28090
Article PK: 77334


> MDA tables, Auditing, Historical server, probably lots of
> others. Have you looked at any of these options?

is it possible for you to give me a query?


Sherlock, Kevin [TeamSybase] Posted on 2009-08-03 16:25:17.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4a770c12$2@forums-3-dub.sybase.com> <4a770ce2.303a.1681692777@sybase.com>
Subject: Re: how do you figure out when a proc was last executed?
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a770f6d$3@forums-3-dub.sybase.com>
Date: 3 Aug 2009 09:25:17 -0700
X-Trace: forums-3-dub.sybase.com 1249316717 10.22.241.152 (3 Aug 2009 09:25:17 -0700)
X-Original-Trace: 3 Aug 2009 09:25:17 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28091
Article PK: 77335

Yes. But you didn't answer my query.

<vtpcnk> wrote in message news:4a770ce2.303a.1681692777@sybase.com...
>> MDA tables, Auditing, Historical server, probably lots of
>> others. Have you looked at any of these options?
>
> is it possible for you to give me a query?


vtpcnk Posted on 2009-08-04 12:09:15.0Z
Sender: 2f94.4a770c03.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.ase.general
Subject: Re: how do you figure out when a proc was last executed?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a7824eb.e57.1681692777@sybase.com>
References: <4a770f6d$3@forums-3-dub.sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 4 Aug 2009 05:09:15 -0700
X-Trace: forums-3-dub.sybase.com 1249387755 10.22.241.188 (4 Aug 2009 05:09:15 -0700)
X-Original-Trace: 4 Aug 2009 05:09:15 -0700, forums-3-dub.sybase.com
Lines: 18
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28095
Article PK: 77337

i did take a look at mda tables. i saw only one table which
had such information - but only for tables and indexes. not
for procedures.

auditing - the dataserver at which i am looking at doesn't
audit/record procedure executions.

i have not used historical server.

> Yes. But you didn't answer my query.
>
> <vtpcnk> wrote in message
> news:4a770ce2.303a.1681692777@sybase.com... >> MDA tables,
> Auditing, Historical server, probably lots of >> others.
> Have you looked at any of these options? >
> > is it possible for you to give me a query?
>
>


vtpcnk Posted on 2009-08-03 16:11:49.0Z
Sender: 2f94.4a770c03.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.ase.general
Subject: Re: how do you figure out when a proc was last executed?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a770c45.2fc1.1681692777@sybase.com>
References: <4a770a22.2e24.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 3 Aug 2009 09:11:49 -0700
X-Trace: forums-3-dub.sybase.com 1249315909 10.22.241.188 (3 Aug 2009 09:11:49 -0700)
X-Original-Trace: 3 Aug 2009 09:11:49 -0700, forums-3-dub.sybase.com
Lines: 6
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28089
Article PK: 77339

> any ideas?

if the suggestion is mda tables, i would appreciate it if
the query is given.

thanks.