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

queries that are run every hour

how to run a query once an hour using sql server 2005
0
rgb192
Asked:
rgb192
  • 2
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
you can schedule a job in sql server agent
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
rgb192Author Commented:
To attach a schedule to a job
1.In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

2.Expand SQL Server Agent, expand Jobs, right-click the job that you want to schedule, and click Properties.


cant find sql server agent
0
 
rgb192Author Commented:
thanks
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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