Running a SQL Server Job from Windows Job Scheduler

[DanAuber]

Am I able to write a batch file to run a SQL Server job ?
If so does anyone know where I can find a guide to the syntax ?

thanks for any help

Dan Auber

 

[vidru]

If you go to a command prompt and type

osql ?

, you'll see the options/syntax needed to run sql commands from a command line (if isqlw.exe is available, you can use it as well).

Here's a sample of what it looks like:

 osql -S SERVER -d dbName -U userName -P Password -Q "exec sp_MyJob"

-dave

 

[JamesLean]

Is there any reason why you want to do this from Windows rather than simply scheduling the job directly from SQL Server?

--James

 

[DanAuber]

Thanks dave

James - because I already have ten jobs in windows scheduler doing other things (not SQL Server related) and I want somewhere where I can manage them all at once....

Dan Auber