Got it working thanks, it was the loginname column had some nulls, so I had to match on a different column. Dohh!

Its not updating multiple rows. Its updating multiple columns on a row. Don't know if that makes a difference. I tried the following, but the update across the db...

Thanks for the advice gentlemen.

Thanks Elisabeth. What we ended up doing was rebooting our sql farm of about 30 sql servers, this must have put the time back in synch and jobs started running...

Thx Terry! Really appreciate the help.