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'

Santhu