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

Sq server 2005 : Table Update when date field value cross current date

P: 1
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,beacause 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. ?
Nov 30 '07 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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,beacause 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. ?

you can create a stored proc and set it to execute everyday 12mn. you can schedule jobs in sql server
Dec 1 '07 #2

Post your reply

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