hello, i have a database that will be updated on a certain date
i have a column "UPDATE_DATE" which specifies the updating date, my question is
"how should i make the trigger or stored procedure runs only on the date that has been specified"
thanks for the assistance
Create a job that runs once everyday and compares the date on the dat with the value in the column, and calls the proc if they match.|||ok, i think that will be good idea since sqlexpress doesn't come with sqlagent
ok then, i'll try to code by that algorithm. thx anyway bro
No comments:
Post a Comment