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.
| Author |
Topic |
|
ramecepa
Starting Member
43 Posts |
 Posted - 2010-07-19 : 06:04:52
|
| Dear All,is there any chance to run sql server2000 job(not DTS) using CMD mode |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-07-19 : 08:33:25
|
| Assuming you have sqlcmd on your server\pc - the following will allow you to run a sql server job. If your requirement is different could you let me know sqlcmd -U myusername -P mypw -S MYSERVER\MYINSTANCE -q "EXEC MSDB.dbo.sp_start_job @Job_Name = 'myjob'"Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
ramecepa
Starting Member
43 Posts |
Posted - 2010-07-28 : 21:01:36
|
| hi bro..where should i run???? |
|
|
|
|
|
|
How can we run sqlserver job using CMD mode