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'


sohairzaki2005Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Languages and Standards

From novice to tech pro — start learning today.