Running jobs from the command line

[johnny99]

Hi

I am trying to move all my jobs, maintenanceplans and DTS to our central scheduling system.

I have used SQLMAINT and SQLCMD for my manitenance stuff.

But is there a way to run the jobs and DTS from the command line and get all the output to stdout?

/johnny

 

[mrdenny]

The command line to run DTS packages is dtsrun.exe.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com