CODEWITHSUNDEEP
sqlscheduled-taskssql-server-2014
Rhonda
Rhonda

Reputation: 1721

Schedule query in SQL Server 2014 Management Studio

I am trying to schedule a SQL query in SQL Server 2014 Management Studio.

For some reason I am unable to find SQL Server Agent (i.e. to expand Jobs to create Schedule).

Is there a new way to schedule SQL query on SQL Server 2014?

Thanks

Upvotes: 0

Views: 2635

Answers (2)

Prayag15
Prayag15

Reputation: 393

You can use Windows Task Scheduler to run your SQL query. Follow below link to creation and deployment of task.

Click here to create windows task

Upvotes: 2

Kevin Fichter
Kevin Fichter

Reputation: 1067

SQL Server Express does not include SQL Server Agent. Editions higher than that (such as Standard, Enterprise/Developer) do.

If your edition supports SQL Server Agent, make sure it is installed.

If it is installed, you may need to configure it before you see it show up as available in SSMS. 

sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
sp_configure 'Agent XPs', 1;  
GO  
RECONFIGURE  
GO

source

This is for the most basic configuration, without regard to permissions and such. For that, it's probably worth reading this short overview.

Upvotes: 1

Related Questions