Re: scheduling dos batch file as job

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 11/14/04


Date: Sun, 14 Nov 2004 03:19:39 +0100

Hi

Look at BOL for "Jobs". SQL Agent can run T-SQL, command line and many other
types of jobs.

The job will run on the SQL Server and not on another machine. If your jobs
are unstable, you may affect the stability of the SQL Agent, and sometimes
SQL Server, so use it with caution.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"hyeebah jones" <hj@haitchjay.net> wrote in message
news:4196a92b@daisy.ans.com.au...
> Hello,
>
> In addition to the automation of standard database jobs
> it would be nice to also coordinate the running of a small
> simple DOS batch file from the SQL job queue.
>
> Can someone advise how to do this? For example, say
> I have a batch file called C:\batch_file.bat and want to run
> this triggered centrally via SQL Server.
>
> What are the optional approached?
> Many thanks for your assistance.
>
>
> HJ.
>
>
>
>