Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
You can use the sp_procoption system stored procedure in master database to mark the stored procedure to automatic execution when the SQL Server will start.