From: Himansu on 10 Dec 2009 12:32
Does anyone know how to submit a stored procedure to execute later in time?
EXEC admin.dbo.pHHA '123', 'junk', 'help'
I want it to execute on 12/20/2009 @ 9:00 AM EST.
From: Plamen Ratchev on 10 Dec 2009 12:53
You can create and schedule a job:
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
> 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.