running stored procedure every 30 minutes

is there a way to run a stored procedure every 30 minutes or so? its a
simple insert statement that i want to run.
thanks,
kam
Set up a SQL Server Agent Job
Via the Enterprise Manager for your database choose
Management -> Jobs
"kameron" <kameron@.discussions.microsoft.com> wrote in message
news:58B18A59-7566-4F56-82FF-18CDEE3BF0DF@.microsoft.com...
> is there a way to run a stored procedure every 30 minutes or so? its a
> simple insert statement that i want to run.
>
> thanks,
> kam
|||Yes, look at SQL Server Agent in Books Online, it has a concept called
scheduled jobs that provide exactly this functionality. You can see
http://www.aspfaq.com/2403 for a very casual walk through the GUI.
http://www.aspfaq.com/
(Reverse address to reply.)
"kameron" <kameron@.discussions.microsoft.com> wrote in message
news:58B18A59-7566-4F56-82FF-18CDEE3BF0DF@.microsoft.com...
> is there a way to run a stored procedure every 30 minutes or so? its a
> simple insert statement that i want to run.
>
> thanks,
> kam
|||> Via the Enterprise Manager for your database choose
> Management -> Jobs
Well, just to be explicit, the management node is at the server level, not
the database level.
A
|||Sure, I wasn't clear. Insert a comma between "Manager" and "for" in
the sentence. Mr Granfield would kill me if he saw that run on sentence.
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u8v8i00yEHA.2788@.TK2MSFTNGP15.phx.gbl...
> Well, just to be explicit, the management node is at the server level, not
> the database level.
> A
>
|||Actually, what I thought you were implying was that there was a
management/jobs section within each database within a specific server in
Enterprise Manager, when of course management is server-wide so it appears
at the same level as databases.
http://www.aspfaq.com/
(Reverse address to reply.)
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:#o2SE50yEHA.2692@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Sure, I wasn't clear. Insert a comma between "Manager" and "for" in
> the sentence. Mr Granfield would kill me if he saw that run on sentence.
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u8v8i00yEHA.2788@.TK2MSFTNGP15.phx.gbl...
not
>

running stored procedure every 30 minutes

is there a way to run a stored procedure every 30 minutes or so? its a
simple insert statement that i want to run.
thanks,
kamSet up a SQL Server Agent Job
Via the Enterprise Manager for your database choose
Management -> Jobs
"kameron" <kameron@.discussions.microsoft.com> wrote in message
news:58B18A59-7566-4F56-82FF-18CDEE3BF0DF@.microsoft.com...
> is there a way to run a stored procedure every 30 minutes or so? its a
> simple insert statement that i want to run.
>
> thanks,
> kam|||Yes, look at SQL Server Agent in Books Online, it has a concept called
scheduled jobs that provide exactly this functionality. You can see
http://www.aspfaq.com/2403 for a very casual walk through the GUI.
http://www.aspfaq.com/
(Reverse address to reply.)
"kameron" <kameron@.discussions.microsoft.com> wrote in message
news:58B18A59-7566-4F56-82FF-18CDEE3BF0DF@.microsoft.com...
> is there a way to run a stored procedure every 30 minutes or so? its a
> simple insert statement that i want to run.
>
> thanks,
> kam|||> Via the Enterprise Manager for your database choose
> Management -> Jobs
Well, just to be explicit, the management node is at the server level, not
the database level.
A|||Sure, I wasn't clear. Insert a comma between "Manager" and "for" in
the sentence. Mr Granfield would kill me if he saw that run on sentence.
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u8v8i00yEHA.2788@.TK2MSFTNGP15.phx.gbl...
> Well, just to be explicit, the management node is at the server level, not
> the database level.
> A
>|||Actually, what I thought you were implying was that there was a
management/jobs section within each database within a specific server in
Enterprise Manager, when of course management is server-wide so it appears
at the same level as databases.
http://www.aspfaq.com/
(Reverse address to reply.)
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:#o2SE50yEHA.2692@.TK2MSFTNGP10.phx.gbl...
> Sure, I wasn't clear. Insert a comma between "Manager" and "for" in
> the sentence. Mr Granfield would kill me if he saw that run on sentence.
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u8v8i00yEHA.2788@.TK2MSFTNGP15.phx.gbl...
not[vbcol=seagreen]
>