checkpoint values greater than

• cdantuon

  Newbie

  Points: 5

  More actions

  February 17, 2004 at 1:50 pm

  #84030

  All,

  I need to create a stored proc that will clean up a table. It will delete any row with a checkpoint value greater than 300ms than the current date and time. I need to create job to notify me whenever checkpoint value is 150 sec greater than

  
  Christine

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 19, 2004 at 9:04 am

  #494727

  What is your checkpoint value? Any example?

  Check function DATEDIFF in BOL.