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)
Printable View
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)
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.
doesnt help
My DBA say yes you can do it. Look into the "Schedule Task" you can run batch job there.
this doest really help either...
nvm it
Use your computer explore to get to it.
Quote:
Originally Posted by mudfish
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.Quote:
Originally Posted by nareth
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.
none if it helps. you just cant do it in mysql so.. bye
The batch file
This call an sql script, might work with mysql, do not know do not have it!Code: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
Good luck m8