Hi There are two ways to do it
1)If it is a sql agent job.you set the startup option in job schedule on to run at startup
2)If you have a procedure u need to enable it to run at startup using
sp_procoption @ProcName = 'YourSP',
@OptionName = 'startup',
@OptionValue = 'on'