Starting sql server job from .net code

Question

I am trying to run a sql job from a Windows service, according to the MSDN pages , and this is a Blog Post I need to run a job by declaring a WORK STAGE NAME . Is there a way to tell START STEP 1 task, so if I don’t need to change the configuration file every time I change the step name?

Answer 1

You can use the sp_start_job stored procedure. The step name is optional. Just execute it like any other stored proc.