By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,655 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,655 IT Pros & Developers. It's quick & easy.

Trigger problem

100+
P: 138
hi experts,
can a function be triggered every day. for example if i want to run a query everyday, how can i write a trigger. i wrote a trigger which runs only when some event occurs but i need it to run automatically say in the specific time lets say.

thanx in advance
Feb 7 '08 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 700
Under Linux you can use cron with a script file, but better way is to use pgagent. To use pgagent you need pgadmin3.
Feb 7 '08 #2

100+
P: 138
hi rski
thanx for the reply. i am using PgAdmin III, could you please kindly tell me how to use pgagent.
thanx
Feb 13 '08 #3

Expert 100+
P: 700
hi rski
thanx for the reply. i am using PgAdmin III, could you please kindly tell me how to use pgagent.
thanx
there is a short documentation
Feb 13 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.