, is not a valid logical operator. Try using
OR, depending on what you need, rows that match either one or both criteria (use
OR) or only the rows that match both criteria (use
You should also avoid writing dates with ambiguous formats, like the
'10/15/2012 00:00:00.000'. Use either
'20121015 00:00:00.000' format. You can read Aaron Bertrand's blog for more details about dates and range queries: Bad habits to kick : mis-handling date / range queries. In this particular query and because the date has no time part, you can also use the shorter
where LastLoginDate >= '20121015'
jobname not like 'Uptest_%' ;