Post reply

dos batch in sql 2000 job step

  • 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

  • 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/

  • 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!

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

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