mysql script?

[nareth]

i want to make it so a row gets deleted after X hours, i do not want to do this with VB.

how can i do this with mysql?(sorry wrong forum)

[mudfish]

The database guy here use a third party add on that will fire exe and other thing like backup! We run sql 2000 think it is called Schedule plus.

[nareth]

doesnt help

[mudfish]

My DBA say yes you can do it. Look into the "Schedule Task" you can run batch job there.

[nareth]

this doest really help either...

nvm it

[mudfish]

Use your computer explore to get to it.

"Schedule Task" you can run a batch job there.

[techgnome]

i want to make it so a row gets deleted after X hours, i do not want to do this with VB.

how can i do this with mysql?(sorry wrong forum)

Then how do you want to do it? As far as I know, there's no way to do it from within mySQL. It needs an outside job. Scheduler works fine (or even a service) on WIndows, if it's on an Apache/Linux/w PHP webserver, then a cron job to run a PHP page couls also do the trick.

Tg

EDIT: Oh, yeah and it will require that there be a time stamp field of somekind so you know how old the record is.

[nareth]

none if it helps. you just cant do it in mysql so.. bye

[mudfish]

The batch file

isqlw -S srv1 -d PERSONNEL -E -i "\\srv2\SRV2DRVE\SQLDBA\Misc\Sql Queries\Personnel\Full_Time_Staff_By_Orgcode.sql" -o Z:\Personal\wkelley\Full_Time_Staff_By_Orgcode.txt

This call an sql script, might work with mysql, do not know do not have it!

Good luck m8