• Lots of good banter. You might also want to see the results of the command. I like the architecture of Job.cmd calling Job.BAT that routes the output to a file.

    Contents of job.cmd look like this:

    c:\job.bat > c:\job.log 2>&1

    The osql line could also use the -b switch will will abort on error.

    Security concerns can be addressed with groups on the box. The type of groups and the permissions associated will depend on the purpose of the batch script.

    Good info Divya