CODEWITHSUNDEEP
sql-serversql-server-2005auto-update
mpcabd
mpcabd

Reputation: 1807

Automated Update SQL Server

I have a table of topics, topics might have an automatic publish date, I want to make SQL Server auto publishes them.

Previously I made it in code on each call to any method of the topics adapter, but I wanna make it automatically in SQL Server.

Can I?

It might be some kinda scheduled job or something like that.

I'm using SQL Server 2005 (Express and Professional).

Upvotes: 0

Views: 153

Answers (1)

David Hedlund
David Hedlund

Reputation: 129792

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

Upvotes: 1

Related Questions