|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 81,
Visits: 857
|
|
Hi David et al,
I am the one who owes apologies, I have no idea how the tagging corrupted the article presentation, and I am sorry that this happened.
I will attempt to rectify this when I can, but it might be a couple of days or so.
Thanks!
Adam
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Today @ 9:00 AM
Points: 1,397,
Visits: 2,748
|
|
You can do a quick fix - though not normally recommended to amend system tables, but the following sets all agent jobs to log to table.
UPDATE [msdb].[dbo].[sysjobsteps] SET flags = 15
Facts are stubborn things, but statistics are more pliable - Mark Twain Carolyn SQLServerSpecialists
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 6:56 AM
Points: 6,
Visits: 186
|
|
If you happen to have a large number of jobs and want to change them all according to this topic; the script below should get the job done without having to manually click through each job/jobstep.
declare @Jobs table (jobId uniqueidentifier) declare @Steps table (stepId int) declare @jobId uniqueidentifier, @stepId int
insert into @Jobs select job_id from msdb.dbo.sysjobs
while exists(select 1 from @Jobs) begin select top 1 @jobId = jobId from @Jobs delete from @Steps insert into @Steps select step_id from msdb.dbo.sysjobsteps where job_id = @jobId while exists(select 1 from @Steps) begin select top 1 @stepID = stepId from @Steps exec msdb.dbo.sp_update_jobstep @job_id=@jobId, @step_id=@stepId, @flags=8 delete from @Steps where stepId = @stepId end delete from @Jobs where jobId=@jobId end
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, December 20, 2010 5:25 PM
Points: 1,
Visits: 2
|
|
| I am on SS 2000, can't get step 6! Any help to debug a job that failed?
|
|
|
|