How to Automate SQL Query

Need help with setting up a scheduled SQL query to run automatically several times a day.
Microsoft SQL Server Management Studio      10.50.1617.0
Microsoft Data Access Components (MDAC)      6.1.7601.17514
Microsoft MSXML      3.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5456
Operating System 6.1.7601
SQL Server R2, Running on Windows Server 2008 Foundation
i created the queary and can run it manually from the management studio interface
need to know if and how to setup this up automatically
all help is greatly appreciated
David ElebuteSystems ConsultantAsked:
Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:
You have two options:

1) Set it up to run as a relatively simple scheduled SQL Server Agent job; or

2) If your needs are a little more ambitious, create an SSIS package to run the query and produce properly formatted output, and then use SQL Server Agent to schedule that SSIS package
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
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.