Delete the log using cron job

[MInu]

Hai all,

I am using Sybase as my back end for my web application.When i execute some complex quries, the connection will lost or i will not get any responds.I increased the size of the tempdb,then the problem solved.But when the user's start to execute the same query,the same issue will happens.Last I found the reason that the log is writing in every event.So i decided to write a cron job to clear the log frequently.
So please anybody help me to write the cron job to clear the log.

Thanks in advance

[Ernest Friedman-Hill]

This has nothing to do with Java, let alone advanced Java; let's move it to Linux/UNIX.

[Craig Jackson]

See below:

Write CRON Job

[Peter Rooke]

Been a while since I used Sybase, but I think you should be able to turn the the logging off. I know there is an option when you create a new database.

Something I quickly dug up: sybase loggin

[Tim Holloway]

There's a facility called logrotate that's explicitly designed to keep logfiles under control. It can keep logfiles in aged generations, starting a new logfile at intervals and/or when the logfile reaches a certain size.