sql server job scheduling

Posted by Anishsethu under Sql Server on 5/3/2012 | Points: 10 | Views : 2054 | Status : [Member] | Replies : 5

i need to change a status of a table automatically, so i created a job scheduling.
it is not working can anyone help immediately

Reply | Reply with Attachment

Posted by: Pandians on: 5/3/2012 [Member] [MVP] Silver | Points: 25

0	Hi Can you tell me the followings... 1. What statement you have used to update the Table ? 2. At what time the JOB should be scheduled ? Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Anishsethu, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Anishsethu on: 5/3/2012 [Member] Starter | Points: 25

0	UPDATE Table SET NAME='123' WHERE DATEDIFF(day,DATE ,GETDATE()) >15 occurs: daily at every 1 min from 12:00am to 12:pm Anishsethu, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Pandians on: 5/3/2012 [Member] [MVP] Silver | Points: 25

0	So, The UPDATE will happen only for those "DATE" column having morethan 15 Days ? Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Anishsethu, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Anishsethu on: 5/3/2012 [Member] Starter | Points: 25

0	but there are dates which had covered 15days, it's status is not changing yet any help? Anishsethu, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Anishsethu on: 5/3/2012 [Member] Starter | Points: 25

0	http://www.zdnetasia.com/develop-an-sql-server-job-from-scratch-62039337.htm i followed above link and scheduled a job. Anishsethu, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts