sql azure - How to create a sql batch/job to update a table once a day -

sql azure - How to create a sql batch/job to update a table once a day -

i new in sql, trying update table 1 time day creating batch, can please guide me through this. appreciate help.

this i'm trying accomplish:

update products set daysleft =( select datediff(day, getdate(), expirationdate) products )

you can create procedure update table , u can create job calling procedure , can maintain frequency of job everyday @ whatever time want set .

for job creation can utilize dbms_job

thanks, abhimpi

sql sql-azure