Thank You Kenneth....That is definatley something to keep in mind.

Could it be because this code is a step inside a job?

Could I possiably create a stored procedure and have the job exec the stored procedure maybe?

Here is the Step 1 that I created.

UPDATE  dbo.ONSA_NSS

SET sent = 1

WHERE sent IS NULL

 AND (datecreated BETWEEN DATEADD(hh, - 2, GETDATE()) AND DATEADD(hh, - 1, GETDATE())) AND (accepteddate IS NULL)

This...

I think that I have to use the command "SET" but not really sure how to use it.

YES!!..That worked very well..Thank you very much.

Can we take this one step further...Now that we found the record that is one hour old, how to I put a value of "1"into...

I am getting a Syntax error with this.

error 156..Incorrect syntax near keyword set

Can anyone help

UPDATE

SET sent = 1

WHERE accepteddate IS NULL

AND datecreated < DATEADD(HOUR, -2, GETDATE())

Ok..Found that section. Are you able to give me a example of the type of commands I would use to check my table for records that are over 2 hours...

I guess I would want to check it every 2 hours to see if a entry is 2 hours old and the person it was dispatched to has not accepted...

Never used Jobs before.

So basicly I would create a job to check and see if the Datecreated field is 2 hours old and the Accepeted date field...