monitoring a table in sqlserver

• noname-210388

  Old Hand

  Points: 331

  More actions

  February 26, 2005 at 4:41 am

  #85546

  hi all,

  is there any way for sqlserver to monitor a table?

  i want to update some records in a table when the time is up.

  there is a table with some fields (xID,xState,xDeadLine)

  i want to update xState field with 1 value when the "GETDATE() >=xDeadline fields value" like this.

  s="UPDATE tableA SET xState=1 WHERE xDeadLine<=" GETDATE()

  i want sqlserver to act this query?

  i dont wanna write any dll or service cos sql server runs on a hosting firm.

  (sqlserver must run the query.)

  thanx,

• wz700

  SSCertifiable

  Points: 7133

  More actions

  February 27, 2005 at 10:47 pm

  #544353

  schedule a job is one option.