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

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 Elebute
David Elebute
2 Solutions
Patrick MatthewsCommented:
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 RetnakaranDatabase AdministratorCommented:

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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