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.

Maintenance Plans

3 posts in General Discussion (old) Last posting was on 2008-08-14 06:31:08.0Z
Markus KARG Posted on 2008-08-13 14:12:15.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
Subject: Maintenance Plans
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48a2ebbf$1@forums-1-dub>
Date: 13 Aug 2008 07:12:15 -0700
X-Trace: forums-1-dub 1218636735 10.22.241.152 (13 Aug 2008 07:12:15 -0700)
X-Original-Trace: 13 Aug 2008 07:12:15 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:106
Article PK: 866552

What is the difference between a maintenance plan and a scheduled event?
Currently I am using a scheduled event for validation and backup.
What is the benefit of using a maintenance plan instead, and why not
replacing scheduled events completely by maintenance plans?


Jeff Albion (Sybase iAnywhere) Posted on 2008-08-13 15:57:50.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: Maintenance Plans
References: <48a2ebbf$1@forums-1-dub>
In-Reply-To: <48a2ebbf$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48a3047e$1@forums-1-dub>
Date: 13 Aug 2008 08:57:50 -0700
X-Trace: forums-1-dub 1218643070 10.22.241.152 (13 Aug 2008 08:57:50 -0700)
X-Original-Trace: 13 Aug 2008 08:57:50 -0700, vip152.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:110
Article PK: 866556

A "maintenance plan" is a user-facing term that we use in the server to
automate common database management tasks (e.g. backups).

There really is no difference, aside from the "wizardness" to the
maintenance plan. Underneath the covers, we execute the appropriate
"CREATE EVENT" SQL statement against the server and acts as it would had
you defined it yourself.

You'll notice that once you have a maintenance plan defined (e.g.
"my_backup") an event also shows up underneath the Events folder in
Sybase Central (as "my_backup_event")

Regards,

Markus KARG wrote:
> What is the difference between a maintenance plan and a scheduled event?
> Currently I am using a scheduled event for validation and backup.
> What is the benefit of using a maintenance plan instead, and why not
> replacing scheduled events completely by maintenance plans?

--
Jeff Albion, Product Support Analyst
Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Markus KARG Posted on 2008-08-14 06:31:08.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
References: <48a2ebbf$1@forums-1-dub> <48a3047e$1@forums-1-dub>
Subject: Re: Maintenance Plans
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48a3d12c@forums-1-dub>
Date: 13 Aug 2008 23:31:08 -0700
X-Trace: forums-1-dub 1218695468 10.22.241.152 (13 Aug 2008 23:31:08 -0700)
X-Original-Trace: 13 Aug 2008 23:31:08 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:120
Article PK: 866566

I see. Then I'll just stay with my current event based solution. :-)

Thanks!
Markus

"Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com> schrieb
im Newsbeitrag news:48a3047e$1@forums-1-dub...

>A "maintenance plan" is a user-facing term that we use in the server to
>automate common database management tasks (e.g. backups).
>
> There really is no difference, aside from the "wizardness" to the
> maintenance plan. Underneath the covers, we execute the appropriate
> "CREATE EVENT" SQL statement against the server and acts as it would had
> you defined it yourself.
>
> You'll notice that once you have a maintenance plan defined (e.g.
> "my_backup") an event also shows up underneath the Events folder in Sybase
> Central (as "my_backup_event")
>
> Regards,
>
> Markus KARG wrote:
>> What is the difference between a maintenance plan and a scheduled event?
>> Currently I am using a scheduled event for validation and backup.
>> What is the benefit of using a maintenance plan instead, and why not
>> replacing scheduled events completely by maintenance plans?
>
> --
> Jeff Albion, Product Support Analyst
> Sybase iAnywhere
>
> iAnywhere Developer Community :
> http://www.sybase.com/developer/library/sql-anywhere-techcorner
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> SQL Anywhere Patches and EBFs :
> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0