Prev: SQL Server 2000 Disable Ad-Hoc Access
Next: Can SQL Server be run locally?
From: Himansu on 10 Dec 2009 12:32
Hello everyone,

Does anyone know how to submit a stored procedure to execute later in time?
Example:

EXEC admin.dbo.pHHA '123', 'junk', 'help'

I want it to execute on 12/20/2009 @ 9:00 AM EST.

Thanks,
Himansu


From: Plamen Ratchev on 10 Dec 2009 12:53
You can create and schedule a job:
http://msdn.microsoft.com/en-us/library/ms187910.aspx
http://msdn.microsoft.com/en-us/library/ms187358.aspx

--
Plamen Ratchev
http://www.SQLStudio.com
From: TheSQLGuru on 10 Dec 2009 16:44
you can also use SCHTASKS and sqlcmd

you can also use sql service broker


--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Himansu" <himansu114(a)hotmail.com> wrote in message
news:OoVA%236beKHA.4880(a)TK2MSFTNGP05.phx.gbl...
>
> Hello everyone,
>
> Does anyone know how to submit a stored procedure to execute later in
> time? Example:
>
> EXEC admin.dbo.pHHA '123', 'junk', 'help'
>
> I want it to execute on 12/20/2009 @ 9:00 AM EST.
>
> Thanks,
> Himansu
>


 | 
Pages: 1
Prev: SQL Server 2000 Disable Ad-Hoc Access
Next: Can SQL Server be run locally?