How to trigger fire automatically?

Question

How to trigger fire automaticallyif date is passed or expire. suppose I have Bookin Table and column meetingdate and meeting status if meeting date is passed then status should be set=X automatically

Abdu Rafeeq · Answer

A trigger is automatically firing or updating the data.That is there is two table one sales table and other one is stock table. if there is a sale happens stock table update automatically by setting if trigger in sales table . In your situation no need trigger.just put job scheduler . For refer http://stackoverflow.com/questions/5471080/how-to-schedule-a-job-for-sql-query-to-run-daily .