Test - SQL Server Forums

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

Site Related Forums

Site Related Discussions

Test

Author

Topic

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2010-01-17 : 11:06:55

[code]
declare @sql varchar(max)
set @sql=''
select @sql=@sql+' EXEC msdb..sp_update_job @job_id='''+cast(job_id as varchar(100))+''',@enabled=0;'
from msdb..sysjobs
where enabled=1
exec(@sql)
[/code]

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

grazuser

17 Posts

Posted - 2010-01-17 : 11:07:23

quote:
Originally posted by graz

declare @sql varchar(max)
set @sql=''
select @sql=@sql+' EXEC msdb..sp_update_job @job_id='''+cast(job_id as varchar(100))+''',@enabled=0;'
from msdb..sysjobs
where enabled=1
exec(@sql)

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

grazuser

17 Posts

Posted - 2010-01-17 : 11:09:29

Test


declare @sql varchar(max)
set @sql=''
select @sql=@sql+' EXEC msdb..sp_update_job @job_id='''+cast(job_id as varchar(100))+''',@enabled=0;' 
from msdb..sysjobs 
where enabled=1
exec(@sql)

Test

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2010-01-17 : 11:10:27

Madhivanan,

I'm struggling to recreate this error. I was able to make it happen once but I can't again. Can you post in this thread and see if you can make it fail?

-graz

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-01-18 : 02:10:46

quote:
Originally posted by graz

Madhivanan,

I'm struggling to recreate this error. I was able to make it happen once but I can't again. Can you post in this thread and see if you can make it fail?

-graz

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

Yes. I am having the same problem that I had earlier

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources