Newbie - Can I have a Timer for a SP?

I'd like to have a stored procedure run every n seconds. Not sure how to
accomplish. Any ideas are appreciated.
Regards,
MikeYou can create a job to execute the stored procedure. To create job open
Enterprise Manager. Expand your Servername. Then click on "Management" then
click "JOB". Right click and click "New Job" and then you can set the SQL
statement to execute that stored procedure and you can set the schedule (the
minimum is every 1 minute).
"Mike Hildner" <mhildner@.afweb.com> wrote in message
news:uMJK3xalDHA.1808@.TK2MSFTNGP09.phx.gbl...
> I'd like to have a stored procedure run every n seconds. Not sure how to
> accomplish. Any ideas are appreciated.
> Regards,
> Mike
>

Newbee Question

Dear All,
What options are available for viewing the report in VB 6.0 application.
Best Regards
VJI sould think so, but not duone it myself. As it's just a cause of
calling an object.
Not sure if you'll beable to use the WebServices and SOAP side.|||You can use SOAP or the Web Service to view the report. One of the Service
Packs for SQL 2000 RS ( if I remember correctly) Also includes some controls
for viewing the reports, ( but I suspect they are DotNet versions.)
A simple thing to do might be simply to open a Windows window with IIS and
pass the URL to the report...Like you would include any web window in VB 6
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<ss> wrote in message news:usvjyWAaFHA.2756@.tk2msftngp13.phx.gbl...
> Dear All,
> What options are available for viewing the report in VB 6.0 application.
> Best Regards
> VJ