Does Sybase got the function like MS SQL's Job?

[Jimmy]

Does anybody know how to make a schedule in sybase? like backup the
database everyday....thanks in advance

[Kumar M]

Create a sql script with backup command and use cron job to schedule
(Unix) and use scheduler (NT)

Kumar

[Patrick Cain]

Use cron in Unix or the NT scheduler. Sybase doesn't have a nice gui for
doing all this (from memory Microsoft's SQL Server does).

We use a batch scheduler product for doing this on Unix/NT .. it's a really
nice way of scheduling thousands of jobs but not worth it for backing up a
few databases.

Has anyone posted their scripts for shutdown & restart/backup/dbcc/update
stats? It would be nice if there was a place to put them then we could all
share and improve.

I've written a couple of sets of these scripts (in ksh) for different sites
I've worked at and would love to see a generic set somewhere.

cheers
Patrick

"Jimmy" <jim...@mail.my.net.tw> wrote in message
news:39a636c9...@news.hinet.net...