May 18, 2007 #1 dbsql IS-IT--Management Mar 29, 2007 19 US Hi all, How can i send Daily history of job to email please.!! thanks
May 18, 2007 #2 mrdenny Programmer May 27, 2002 11,595 You can query it from the msdb.dbo.sysjobhistory table. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration) MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com Upvote 0 Downvote
You can query it from the msdb.dbo.sysjobhistory table. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration) MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com