SQL job on startup

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

In a schedule, you can choose "Start automatically when SQL Server Agent starts" as the schedule type.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

alfgomled SSC Journeyman Points: 77 More actions · Answer 2

Hi,

have a look at this article:

Regards.

santhubt Mr or Mrs. 500 Points: 591 More actions · Answer 3

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