I'm setting up a Maintenance Plan in SQL 2005. It is a simple plan to just backup sql databases. After the JOB is done, I want it to email me with a report of the summary whether it's failed or succeeded.
How do I go about doing that?
I was able to setup an SQL Operator, and use the NOtifiy Operator Task at the end but that just seems to be a way to email a person with a generic text that I define and not the actual summary report
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…