I have a quartz.net scheduler.My scheduler consist of one job and three trigger. This trigger will work on minute mode and will fire every 1 minute,every 5 minute and every 10 minute.And while execute the job it will insert the data into a table. My problem is that when trigger time overlaps it will cause an exception 'violation of Primary Key constraint. Cannot insert duplicate key '. Is it possible to make my trigger to wait when they doing same job at same time.?
how can i overcome this?