dos batch in sql 2000 job step

• Filippo-391925

  Mr or Mrs. 500

  Points: 587

  More actions

  February 22, 2007 at 1:32 am

  #62352

  hi all!

  i am a neo sql administator and i have a little question for you.

  i need to execute a batch in a job's step, but i don't want to use master..xp_cmdshell to call to an external .cmd file.

  in particular i need to execute a FIND in a log file, setting some vars and doing an IF condition on %errorlevel% status.

  can i execute these steps directly in a sql job's step?

  how can i do that?

  thanks in advance

  Filippo

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  February 22, 2007 at 3:41 am

  #691103

  generally I tend to call batch files - choose the Operating System Command ( CmdExe ) step type in the job.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• Filippo-391925

  Mr or Mrs. 500

  Points: 587

  More actions

  April 6, 2007 at 10:59 am

  #699056

  hi,

  finally i call external batch files in my sql server jobs. it is the better way to have single log files and more flexible for other users in the team.

  Thanks!