Re: scheduling dos batch file as job
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: Sun, 14 Nov 2004 03:19:39 +0100
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.
Mike Epprecht, Microsoft SQL Server MVP
MVP Program: http://www.microsoft.com/mvp
"hyeebah jones" <email@example.com> wrote in message
> 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.