I'm looking to set off a trigger not as a function an operation performed on a table but rather to have
it go off at at a preset time. What would be the best way to do that?

More specifically I want to do the following:

It's 6:32PM
run a specific SELECT statement
If SELECT statment returns no records then
INSERT a record into the table.

I could write a small background application to do this but it seems more elegant to
do it within the database iteself.

Thank you

Oliver

Oliver


ElevateDB comes with Jobs which is what I think you want. I've never used them so can't say for sure but I think you'll need to be running client/server.

Roy Lambert [Team Elevate]

Oliver,

<< More specifically I want to do the following: >>

What you want is a JOB:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=CREATE_JOB

You can also easily create a job using the EDB Manager under the Jobs node.

The only catch is that the EDB Server is the only thing that can execute
jobs.  Local applications cannot do so.

--
Tim Young
Elevate Software
www.elevatesoft.com