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

simulating the functionality of sp_makewebtask to create RSS and Activate them

I am working with sql 2008. Is there a way to simulate sp_webmaketask stored procedure.
It is depreciated in sql 2008.
I used it to create and schedule rss feeds
How can I do that without using .net
sp_makewebtask
@outputfile = 'C:\Rss.xml', ---- Point 1
@query = 'Exec GenerateRssFeed', -- Put the SP name here
@templatefile = 'C:\RssFeedTemplate.xml' -- Point 2

-- for the template
<?xml version="1.0" encoding="utf-8" ?>
<channel>
<title>SSWUGJust Published</title>
<description>The SQL Server World Wide User Group ...</description>
<link>http://www.sswug.com</link>
<language>en-us</language>
<%begindetail%>
<%insert_data_here%>
<%enddetail%>
</channel>

--for scheduling the task
sp_makewebtask
@outputfile = 'C:\Rss.xml',
@query = 'Exec GenerateRssFeed',
@templatefile = 'C:\RssFeedTemplate.xml',
@whentype = 10,
@datachg='TABLE=ArticleMaster COLUMN=ArticleId,AName,ADesc,PubDate'


0
sohairzaki2005
Asked:
sohairzaki2005
  • 2
1 Solution
 
Anthony PerkinsCommented:
The best you can do with T-SQL alone is use the FOR XML clause.
0
 
sohairzaki2005Author Commented:
Thanks I've done that before but I need the functionality of activitating it automatically.
When I used sp_makewebtask the @whentype helped to do that and also the idea of the xmltemplate was greate.
Does SQL 2008 has an alternative way of doing what sp_makewebtask did for rss before other than ssis?
0
 
Anthony PerkinsCommented:
>>Does SQL 2008 has an alternative way of doing what sp_makewebtask did for rss before other than ssis?<<
There recommendation is to use SQL Server Reporting Services.  See here:
Discontinued Database Engine Functionality in SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms144262.aspx
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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