• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

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

0
al4629740
Asked:
al4629740
  • 4
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
schedule a sql server agen job
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
al4629740Author Commented:
I can't find the SQL Server Agent
0
 
al4629740Author Commented:
i have 2005 sql express
0
 
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now