schedule to run a query every hour

I have a query below that I would like to run every hour on the server.  How can I do this?
Update AttendanceGrid Set X = case when tblRegistration.Overage = 3 THEN  'X' else '' end FROM tblRegistration INNER JOIN AttendanceGrid  on tblRegistration.id=AttendanceGrid.id

Open in new window

al4629740Asked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
the agen is not available in Express edition, you can either use the free tool like http://www.lazycoding.com/products.aspx
or http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
schedule a sql server agen job
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
al4629740Author Commented:
I can't find the SQL Server Agent
0
 
al4629740Author Commented:
i have 2005 sql express
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.