June 17, 2009 at 11:15 pm
Hi All,
Can anyone tell me how to implement schedular in SQL so that the Schedular will execute a Query or SP everyday or everyweek on certain time.
Thank You All
June 18, 2009 at 12:15 am
Try creating maintenance plan to execute your sp
Tanx 😀
June 18, 2009 at 1:38 am
Hello,
I suspect it is a SQL Server Agent Job that you need.
Please see the SQL Server Books Online Topic “Implementing Jobs”.
BTW - Which edition of SQL Server do you have?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
June 18, 2009 at 2:17 am
Hi,
Thank you for the Reply. I am having SQL2005
June 18, 2009 at 2:49 am
Hello again,
I asked because the SQL Server Agent is not included in the Express edition of SQL Server 2005. I hope you have one of the other Editions.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply