AB-test

Notify multiple operators with difference results

The other day I was asked How to notify multiple operators using database mail for failed jobs and a different operators for successes.

First I looked at the operator email addresses field 1@a.com;2@b.com….etc is not helping as there is a limit on the characters in the email name entry of operator and we still have the problem we need different groups for success and failures.

enter image description here

So this is what I came up with as a workaround if the intention is that multiple people in your organization should be notified if a job fails and a different group of multiple people for successes.

You will notice the Steps 1-3 are the normal tasks that the schedule job is uses for as you would do for your task. There can as many steps as needed before these but the last step (Step 3) of the process need to break “On Success” and “On Failure” to go into separate emails. Also all “On Failures” need to continue to your “Failure Email” as highlighted below. So the Failure group gets there emails and the job will still fail for the historical records.

1.1

 

You will see the option to change the direction of the “On success action” and “On Failure action” in the Advanced tab of the Job steps.

2

Failure Email Step -General Property

3

Failure Email Step -Advance Property

4

Success Email Step -General Property

5

Success Email Step -Advance Property

6

 

I hope this helps. Happy Coding. Have FUN!

 

Top-10-business-intelligence-requirements

I will be Attending Southeastern Business Analytics Community

Excited to have a full afternoon of gathering with other BI professionals. Come join us whether you utilize Cognos BI, Cognos TM1 or IBM SPSS and are looking for ways to get full business value from your data, optimize performance management, or just interested in learning more about the latest IBM solutions, please register now for this valuable event.

Friday
April 22, 2016
11:00 AM – 3:00 PM

DataClarity Corporation – Southeastern Business Analytics Community

The Southeastern Business Analytics Community invites you to join IBM, DataClarity, and your peers on Friday, April 22 nd for the Spring Meeting of the Business Analytics User Group, an exclusive gathering of experienced professionals and IBM experts for real-world tips and best practices to help you harness the power of analytics in your organization.

Hope to see everyone there!

Microsoft’s PowerBI and Datazen

This week I’m going to be looking for differences in the two products at PASS Business Analytics. First initial look is one is cloud and one is on prem. Fiserv’s Bank Intelligence – bank/ credit union solution team has been on the search for a product to give our home grow BI product a face left. We have looked at Tableau, QlikSense, Cognos, Brist. This week @ #passbac I’m going to talking to people and get a real good idea on how PowerBI and Datazen could be a Fiserv solution. Stand by for updates.

PowerBI

  • Mobile

 

Datazen

  • Mobile

Surface Pro 3 for a DBA a ture laptop/Desktop/iPad replacement

285_surface

SQL PASS 285 Tech Tattoo on Surface Pro 3

IMG_2211

Microsoft Store in Lenox Square Mall in Atlanta

Setting up in August 2014

Setting up in August 2014

Back in August 2014 I decided to get a Microsoft Surface Pro 3 and mother was in need of a new laptop as well so we went together to investigate at the Microsoft Store in the Lenox Square Mall in Atlanta. Needless to say we pulled the trigger and made the purchases. Thanks Mom!:-) We both went with the Surface Pro 3 – 256GB / Intel i5 to get the version with 8GB RAM. I felt like I wanted the extra RAM for SQL Server and I’m glad I did. Over the past months this machine has been my laptop and tablet; I have still been using the iPhone for phone/email. I have added a few links below to help with the over experience be easier for other DBAs. I had no problem the first evening installing Microsoft SSMS 2014 and Visual studio 2012 from my ISO files. I also went ahead and added Red-Gate developer tools and SSMS Tools Pack. The installations went super fast with the SSD onboard. If you are hoping that the Surface is going to satisfy your need for apps; think again. Microsoft is lacking the apps in the marketstore. The big ones are there but I use the IE web for mostly everything and if you can install your everyday software.

At home I had an exisiting KVM IOGear Extreme 4 port KVM which got me the keyboard and mice working right away.

Before SQL PASS Summit 2014 I had to purchase the Plugable UD-3000 Universal Docking Station USB 3.0 to get the NIC and docking station feature for my PreCon on Big Data. In December had a small issue with the Intel drivers and the Plugable 3.0 to resolve check out: Plugable Blog

3

Surface Pro 3 and Plugable UD-3000 Universal Docking Station USB 3.0

2

IO Gear KVM and Second Monitor to Surface Pro 3

I also had a small issue with the WiFi not working automatically connecting after I enable the Hyper-V. Hyper-V functionality in Windows 8.1 doesn’t play nice with Surface Pro 3’s Connected Standby. Article: Surface Pro 3 Tip: Hyper-V vs. Connected Standby. So I have some saved batch files to enable and disable WiFi and Hyper-V.

Surafce SSMS

Magnets in this Cover connect with magnets in Surface Pro 3 to add stability when you’re typing on your lap. Like Type Cover 2, this Cover has backlit keys, with keys on the left side of the top row of keys to control keyboard brightness.

Screenshot

SSMS Screenshot from Surface Pro 3

Some useful links I used to make my purchase decision:

The Surface Pro 3 is a very good Windows 8.1 device I would recommend it to any DBA for home and business use. I’m also excited to see it working with Windows 10 Tech Preview.

PASS Summit 2014…. 3rd Year!

sqlpass1

SQLHiker Family in Pike Place Market

sqlpass2

Selfie in Session

1

SQL karaoke

 

2

Space Needle

 

I’m back from the PASS Summit 2014 which had 3,941 delegates and 1,959 pre-conference registrations across 56 countries for a total of 5,900 registrations. The event’s sold-out Exhibit Hall features 57 partners, including Platinum sponsors Dell Software and HP. The visible first-timers badges were everywhere. My third year and keeps getting better each year. I did a lot of the usual things, walked in #SQLwalk, attended two pre-conference seminar, catching with coworkers and friends, visited with exhibitors, and went to a few after hours events (that included karaoke). You know, the remarkable Summit stuff. I was sporting my new t-shirts and sqlhiker logo designed by Daniel McLeod. Pre-conference I attended Big Data: Deploy, Design, and Manage Like a Pro with Adam JorgensenJohn Welch, and Buck Woody this was a well put together seminar the presenters knew there material. The level and nature of participation from students and presenters was simply exceptional, concrete exercise, concrete examples, excellent analysis and feedback. The time flew by! The second pre-conference I shadowed along in the SSIS: Problem, Design, Solution presented by the Knight brothers Brian KnightDevin Knight. The seminar materials were well worth it and included the two first class SSIS speakers insight for 5 hours; liked there approach.I also attended a series of PASS sessions at the event. I really enjoyed the sessions “Bullet-Resistant SSIS Packages” by Tim Mitchell and” Join Us! Getting Started as a Technical Speaker” by Eddie Wuerch. Both went be on the usual for explaining their topic. They are speakers I hope to be someday. I also went to a couple of community sessions in and around the work I will be doing at Fiserv. All good sessions; but this year is the first time I took a technical speaking course and something has clicked. I always knew enjoyed speaking and doing company Lunch n Learns. Just never thought about doing it for other DBA’s. So this year I’m setting new goals: Complete 24 blog post, volunteering some time to the Atlanta MDF chapter, and submitting as a speaker in a SQL Saturday. I just need to work out the timing and a topic. Any recommendations are welcome.With the long Veteran day following week after the conference; it gave my wife and I a chance to celebrate our anniversary and take in the tourist sites for an extra few days: Space Needle, Pike Place Market, Crab House, Bainbridge Island, Chihuly Garden and Glass, Seattle Great Wheel and Seattle Art Museum: SAM.The Summit is always a special event for me each year. I have been to many technical conferences in my career, but none compare to the experiences I’ve had since I began participating at PASS Summit. Whether you’re an attendee or a speaker, your experience will be enhanced exponentially by participating. First timer? No problem! This community welcomes you and wants you to have a positive experience. All you have to do is engage with other people. Smile. Ask a question. I hope to meet you and make your acquaintance.