Disabling SQL jobs using command line  
Author Message
Aptiva





PostPosted: Wed Feb 14 04:57:22 CST 2007 Top

SQL Server >> Disabling SQL jobs using command line

Hi,

Is it possble to disable a SQL using command line?

If so, pls show me how or direct me to somewhere where I can find the
information.

Thanks in advance

SQL Server28  
 
 
Jens





PostPosted: Wed Feb 14 04:57:22 CST 2007 Top

SQL Server >> Disabling SQL jobs using command line Simply stop the service, see the Screencast on my website for more
detailed information.

In summary you just use the NET STOP command.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

 
 
Jens





PostPosted: Wed Feb 14 05:04:33 CST 2007 Top

SQL Server >> Disabling SQL jobs using command line Sorry did not read the "job" in the subject:


UPDATE sysjobs
SET enabled = 0
WHERE jobId = 'SomeId'

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

 
 
Jens





PostPosted: Wed Feb 14 05:05:58 CST 2007 Top

SQL Server >> Disabling SQL jobs using command line Or

calling sp_update_job via SQLCMD or OSQL.

(No I think I am done. :-) )

 
 
Tibor





PostPosted: Wed Feb 14 05:04:43 CST 2007 Top

SQL Server >> Disabling SQL jobs using command line Check out sp_update_job.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/



> Hi,
>
> Is it possble to disable a SQL using command line?
>
> If so, pls show me how or direct me to somewhere where I can find the information.
>
> Thanks in advance
>


 
 
Paul





PostPosted: Wed Feb 14 05:06:45 CST 2007 Top

SQL Server >> Disabling SQL jobs using command line Sure. try:

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com


 
 
AppleDopod





PostPosted: Thu Feb 15 05:14:16 CST 2007 Top

SQL Server >> Disabling SQL jobs using command line Thanks everyboday. It worked great!!



> Sure. try:

> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>