InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 21:07:48 GMT20http://www.sqlservercentral.com/Forums/Topic1384189-146-1.aspxHi There are two ways to do it1)If it is a sql agent job.you set the startup option in job schedule on to run at startup2)If you have a procedure u need to enable it to run at startup usingsp_procoption @ProcName = 'YourSP', @OptionName = 'startup', @OptionValue = 'on'SanthuTue, 20 Nov 2012 02:58:44 GMTsanthubthttp://www.sqlservercentral.com/Forums/Topic1384189-146-1.aspxHi,have a look at this article: http://www.databasejournal.com/features/mssql/article.php/3550601/Automatically-Running-a-Process-When-SQL-Server-or-SQL-Agent-Starts.htmRegards.Thu, 15 Nov 2012 04:13:19 GMTalfgomledhttp://www.sqlservercentral.com/Forums/Topic1384189-146-1.aspxIn a schedule, you can choose "Start automatically when SQL Server Agent starts" as the schedule type.Tue, 13 Nov 2012 23:56:31 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1384189-146-1.aspxHi All,How could I run a sql job or maintenance plan on server startup?ThanksTue, 13 Nov 2012 10:26:17 GMTinfo-849042