ansaurus

Question

Answer 1

+1 A:

What do you mean by 'publish'? It definitely sounds like you could use a SQL Server Agent job, to execute, say

UPDATE topics SET published = 1 WHERE publishdate < getdate()

if that is what all what you want to do, when you refer to 'auto publish'

EDIT

Since a SQL Server Agent job won't do. How about modifying your selects instead?

SELECT
   (published OR publishdate < getdate()) as published
FROM
   topics

David Hedlund 2009-07-09 14:47:18

I linked to SQL Server Agent explanations for you. However, it's worth noting that SQL Server Express doesn't come with SQL Server Agent. You need Standard+ for this.

Eric 2009-07-09 14:50:56

Thanks for answering, I know I have to user SQL Server Agent, but as Eric commented, I have SQL Express :(Is there another way?

mpcabd 2009-07-09 15:04:42

oh. thanks for pointing out. set up a simple windows service, perhaps, that's running in the background and polling the database to execute an sp at a given interval? it's quite simple to do in .net, at least, but no, it's not all-sql.

David Hedlund 2009-07-09 15:21:49

(i also added an alternative approach in an edit to this post, but i actually think i'd prefer to go for the win service myself)

David Hedlund 2009-07-09 15:23:48

Thanks for the service point, but I'm running the webiste at a remote host that I can't install services on.I liked the other approach, I'll try to find a way to put it in my code again :)Thanks.

mpcabd 2009-07-12 10:21:01

ansaurus

tags:

views:

answers:

Automated Update SQL Server

related questions