rgb192
asked on
queries that are run every hour
how to run a query once an hour using sql server 2005
you can schedule a job in sql server agent
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
thanks