Disabling SQL jobs using command line
Index
‹
SQL Server
‹
SQL Server
Author
Message
Aptiva
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: 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
>
Index
‹
SQL Server
‹
SQL Server