Re: Timed Events

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 10:16:57 -0600

Create the stored procedure
and schedule it to run via SQL Server Agent.

The easiest way to setup a job to run is to open Enterprise Manager
Open the Managemnt folder
Open the SQL Server Agent node
Jobs
right-click; new job 

-- 
Keith
"P1ayboy" <P1ayboy@discussions.microsoft.com> wrote in message
news:7147E8D3-AA73-4009-A742-55B8748E9FE7@microsoft.com...
> How can I write a stored procedure that runs at a particular time every
day?
> Eg. 09:00.

Relevant Pages

  • RE: master..xp_cmdshell Error 997 from GetProxyAccount
    ... Start SQL Enterprise manager ... right mouse on SQL Server Agent and select properties ... select Job System tab ... > This all works when the stored procedure is fired inserting the record ...
    (microsoft.public.sqlserver.programming)
  • RE: master..xp_cmdshell Error 997 from GetProxyAccount
    ... Start SQL Enterprise manager ... right mouse on SQL Server Agent and select properties ... select Job System tab ... > This all works when the stored procedure is fired inserting the record ...
    (microsoft.public.sqlserver.security)
  • Package fails when run from Sql Server Agent
    ... I have a stored procedure that createz a DTS package on the fly using ... Step error code: 8004206A ... What would cause some rows to fail when using Sql Server Agent? ...
    (microsoft.public.sqlserver.dts)
  • SQL Server Agent - stored procedure
    ... I have a stored procedure which I run from SQL Server ... into a database, and if a duplicate key exists, it puts it ... to have SQL Server Agent behave the same way? ...
    (microsoft.public.sqlserver.programming)