Can anyone help me in setting up automated action? For eg i want to send mail when product quantity is less than 100.
Have a look at http://doc.openerp.com/v6.1/book/2/3_CRM_Contacts/opport.html or you can have CRM example in
Setting->Technical->Automated Actions. There in
Action Type you can define
You can also use Scheduler for regular interval of time
There you can specify your interval time in Minutes,Hours,Days,Week,Month & you can also specify no. of calls that means intervals.