auto run store procedure

Question

Post reply

auto run store procedure

shekhar roy

Grasshopper

Points: 11
More actions
March 14, 2007 at 5:17 am

#123239

can any body help me...

i am not able to find out how to execute a store procedure every day on a particular time...

regards
shekhar

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

David Burrows SSC Guru Points: 65144 More actions · Answer 1

Look up in BOL (Books Online)

How to create a job (Enterprise Manager)

Creating Job Steps (specifically Transact-SQL Job Steps as you will want to EXEC your proc)

How to schedule a job (Enterprise Manager)

You can also do this using MS stored procs (also documented in BOL)

Far away is close at hand in the images of elsewhere.
Anon.

Sharad Pratap Singh Grasshopper Points: 15 More actions · Answer 2

Create small DTS package using Enterprise Manager and schedule it to run daily.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

There's no need to create a DTS package just to run a stored proc. A SQL Agent5 job is more than sufficient.

No need to add additional complexity.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Scott Arendt SSCrazy Eights Points: 8218 More actions · Answer 4

I second the use of SQL Agent to accomplish this.

One step within SQL Agent would accomplish it.

Regards,

Scott

zubamark Right there with Babe Points: 785 More actions · Answer 5

Management folder>jobs>right click>create new job>go to: 1.steps>new>choose database>command:>execute [db name].dbo.[your sp]2.schedule.

fernando-417941 SSC Rookie Points: 27 More actions · Answer 6

los trabajos son ejecutados por el agente de sql server enterprisse, estos tienen varias funcionalidades y pueden ejecutarse programados en el tiempo. a su vez pueden comunicar del resultado de los trabajos mediante e-mail u otra forma de comunicacion. generalmente son utilizados para ejecutar stores proceedures de usuarios o sistema, enviar mails, ejecutar acciones ante errores generales, etc.

para esto debes crear un trabajo, establecer un paso... y dentro de ello escribir:

exec nobreprocedimiento y lista de parametros para procedimientos...

luego realizar la programacion del mismo. hay varias opciones

use google for trad this msj, sorry, my englis is bad... sorry

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 7

Simplicity - SQL Agent Scheduled Task.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."