I have made a script which logs the users ip into a table.
Here is the table:
ID - PKEY A.INC
IP - VARCHAR
ENTERED - TIMESTAMP
What I would like to happen is that after a row has been inserted, I want to set up a sql JOB, to automatically tjeck this table for rows which are >= 24 hours old, and if found, then delete the row.
Or if it is easier to create: If time is 00.00 then delete all records in the table, that could support my idea too :-)
It is for a voting system on a website.
The only thing is, that I have never been near creating a JOB in SQL, I have just stuck to SELECT, UPDATE, DELETE statements.
It is the very last thing I need for finishing my exam project, and I hope someone can be helpful.