Re: scheduling dos batch file as job
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 11/14/04
- Next message: Mike Labosh: "DBCC DEFRAGINDEX"
- Previous message: hyeebah jones: "scheduling dos batch file as job"
- In reply to: hyeebah jones: "scheduling dos batch file as job"
- Next in thread: Andy Phillips: "Re: scheduling dos batch file as job"
- Messages sorted by: [ date ] [ thread ]
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.
>
>
>
>
- Next message: Mike Labosh: "DBCC DEFRAGINDEX"
- Previous message: hyeebah jones: "scheduling dos batch file as job"
- In reply to: hyeebah jones: "scheduling dos batch file as job"
- Next in thread: Andy Phillips: "Re: scheduling dos batch file as job"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
