Carlos Leon-404864
SSC Rookie
Points: 41
More actions
October 15, 2009 at 9:34 am
#136464
Any comments or ideas on why the systasks view in msdb no longer exists in SQL Server 2005/2008. What other table(s)/view(s) are replacing it.
dbo.benyos
SSCommitted
Points: 1944
October 15, 2009 at 9:57 am
#1066371
http://msdn.microsoft.com/en-us/library/aa197123(SQL.80).aspx
systasks contained one row for every scheduled task. Removed; replaced by sysjobs, sysjobsteps, and sysjobservers. Remove all references to systasks and replace with references to sysjobs, sysjobsteps, and sysjobservers as appropriate.
Tal Ben Yosefwww.TalBenYosef.com(visit my LinkedIn profile)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply