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.

Database Event in Use

4 posts in General Discussion Last posting was on 2007-11-20 21:45:39.0Z
Herman Miller Posted on 2007-11-19 16:01:41.0Z
Sender: 7c5f.4741ac4f.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Database Event in Use
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4741b365.7cd8.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Nov 2007 08:01:41 -0800
X-Trace: forums-1-dub 1195488101 10.22.241.41 (19 Nov 2007 08:01:41 -0800)
X-Original-Trace: 19 Nov 2007 08:01:41 -0800, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6589
Article PK: 4837

How do I shutdown a database event so I don't get event in
use when trying to update database event script?


Chris Keating (Sybase iAnywhere) Posted on 2007-11-20 12:33:23.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Database Event in Use
References: <4741b365.7cd8.1681692777@sybase.com>
In-Reply-To: <4741b365.7cd8.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Message-ID: <4742d413$1@forums-1-dub>
Date: 20 Nov 2007 04:33:23 -0800
X-Trace: forums-1-dub 1195562003 99.236.107.169 (20 Nov 2007 04:33:23 -0800)
X-Original-Trace: 20 Nov 2007 04:33:23 -0800, cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Lines: 5
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6597
Article PK: 4845

Look at "Disable" in the ALTER EVENT.

Herman Miller wrote:
> How do I shutdown a database event so I don't get event in
> use when trying to update database event script?


Herman Miller Posted on 2007-11-20 13:54:44.0Z
Sender: 1720.4742e696.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: Database Event in Use
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4742e724.1736.1681692777@sybase.com>
References: <4742d413$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Nov 2007 05:54:44 -0800
X-Trace: forums-1-dub 1195566884 10.22.241.41 (20 Nov 2007 05:54:44 -0800)
X-Original-Trace: 20 Nov 2007 05:54:44 -0800, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6602
Article PK: 4851

Can I alter and disable an event while it is in use?

> Look at "Disable" in the ALTER EVENT.
>
> Herman Miller wrote:
> > How do I shutdown a database event so I don't get event
> > in use when trying to update database event script?


David Fishburn Posted on 2007-11-20 21:45:39.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Database Event in Use
From: David Fishburn <fishburn_spam@off.ianywhere.com>
References: <4742d413$1@forums-1-dub> <4742e724.1736.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns99EEAA4F5A8ECfishburnsybasecom@127.0.0.1>
User-Agent: Xnews/2005.10.18 Hamster/2.1.0.0
NNTP-Posting-Host: vpneast-client-081.sybase.com
X-Original-NNTP-Posting-Host: vpneast-client-081.sybase.com
Date: 20 Nov 2007 13:45:39 -0800
X-Trace: forums-1-dub 1195595139 10.18.242.88 (20 Nov 2007 13:45:39 -0800)
X-Original-Trace: 20 Nov 2007 13:45:39 -0800, vpneast-client-081.sybase.com
Lines: 28
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6603
Article PK: 4852

Herman Miller wrote in news:4742e724.1736.1681692777@sybase.com
of ianywhere.public.general:

HM> Can I alter and disable an event while it is in use?

Try it and tell us what happens.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList