I am using Sql server 2005.
I have one table named 'tblJob'. This table have two fields say 'Staus' and 'ExpiryDate'.
when 'Expirydate' come to less than current date, i want to upadte 'Status' field.
(Can't use trigger,beacaus e we don't know when date cross the currrent date)

Do i need to write a seperate application for that and add it in windows scheduler?
Is there any option in Sql server 2005. ?