Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Trigger at particular time |
Mon, Jan 24 2011 7:58 PM | Permanent Link |
Oliver METTRIX | 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 |
Tue, Jan 25 2011 3:44 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Wed, Jan 26 2011 3:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |