How can we run sqlserver job using CMD mode

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

How can we run sqlserver job using CMD mode

Author

Topic

ramecepa
Starting Member

43 Posts

Posted - 2010-07-19 : 06:03:51

Dear All,
is there any chance to run sql server2000 job(not DTS) using CMD mode

oldjeep
Starting Member

5 Posts

Posted - 2010-08-06 : 08:52:00

Sure - using the commandline you can use osql
--trusted authentication
osql -E -d MSDB -Q "sp_start_job 'MySQLJob'"

--SQL server authentication
osql -U user1 -P password -d MSDB -Q "sp_start_job 'MySQLJob'"

Chuck P

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources