Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Executing Queries

Author  Topic 

mshsilver
Posting Yak Master

112 Posts

Posted - 2014-04-24 : 05:48:49
Hi,

I might be in the wrong part of the forum with this question.

I have several SQL queries built that I want to schedule to run once a day. Unfortunately I only have SQL Server 2008 Express which has no agent service so I think I might be unable to achieve this.

Are there any other options that anyone can think of so that I can have these queries execute on the server?

Many thanks for taking the time to look.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-04-24 : 06:14:20
use SQLCMD + Windows Scheduler

also see http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express



KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

mshsilver
Posting Yak Master

112 Posts

Posted - 2014-04-30 : 06:37:52
Many thanks for this, i will give it a go.
Go to Top of Page
   

- Advertisement -