Send email "When the job completes" Will send an email when the job completes, regardless of if it was successful or failed. If the job fails it will tell you...

You would need each task (apart from the last) to be:
On Success go to next step; On failure quit the job reporting failure.

This will cause the job...

If step 1 is set to go to step 3 on failure, then no, it won't email you. The Email notification to operator is on job failure, not task failure....

Sorry to disappoint you Brandie, but going for something "on topic" too.

I'm considering doing the Microsoft Certifications sometimes in the "near" future, and wanted to check if people...

With no consumable data, here's an example of how you would use SUM and CASE together:
CREATE TABLE #Sample
  (menu1 varchar(10),
  menu2 varchar(10),
  ...

You are correct sir, due to the not equal part. It doesn't sit right with me though, XORs, in SQL, should be two part 😛

This almost sounds like the OP is wants to do an XOR statement, so the logic wanted is? Visible = 0 XOR [Type] <> 14

I think you need to explain your logic further then. I really don't understand how you're linking your id's and client_ids in your expected out. Although I gave the example...

Plucking a random example from your above post how do you expect the get the row:
id       client_id  amount
-------  ---------  ------
2093838  55966777   100.00

Looking at...

If it's behaving as it's supposed to be, what's the problem? I assume you mean it is not? 🙂 Could you explain how/why it isn't?

Which of the following are you seeing?
SQL Server Instance is stopped.
SQL Server Agent for the instance also stops (due to stopping).
SQL Server Instance starts.
SQL Server Agent...

I have VS 2008, 2012 and 2016 installed on my PC at the office and have no problems. Yes i mainly use 2016 now, but they all had their respective...