Execute Batch File

• gupta1282

  Default port

  Points: 1465

  More actions

  October 12, 2009 at 3:16 am

  #136448

  Respected All

  I want to execute a batch file on system start up that call a sql script file but the problem is that untill sql server service not started , the batch file should not run means that if batch file start running before sql server service starts , it will fail

  so is there any why to run this batch file after sql server service start and only when system boots.

  Please help me

  Thanks

  Ghanshyam

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  October 12, 2009 at 3:54 pm

  #1064967

  You may want to look at setting a proc to fire whenever SQL is restarted

  exec sp_procoption

  @ProcName = 'YourProcName',

  @OptionName = 'startup',

  @OptionValue = 'on'

  Andrew

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  October 12, 2009 at 5:38 pm

  #1064981

  Can we ask what this script does because while what you are asking is generally possible it would help to know the problem being solved.

  CEWII