mhenry

Figured it out. Just in case anyone else runs into this error. Changing the password in MySQL won't work. Had to drop user from MySQL then recreate using the standard setup script: CREATE USER '<USER>'@'%' IDENTIFIED BY '<PASSWORD>'; GRANT ALL PRIVILEGES ON database.* TO '<USER>'@'%'; Not sure why, but this did work. 

So that got me thinking. I changed it up a bit and used this. And it worked! SELECT CASE WHEN EXISTS( SELECT field FROM table WHERE date_last_updated > getdate()-0.02083 AND field IS NULL) THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END

Looks like I do. I just started working on this database, but there are three columns in this table. We have date_created, date_last_modified and one called date_order_completed. I may have to play with it a bit but I'm sure one of those will work. Let's use date_created for whatever you have in mind. Thanks, mh

So on the chart in Resources for Sessions, if it shows one blocked session that's the sessions that have been blocked on average? I was hoping to find out that the measurement was in 100s or something.

ok, so I'm trying this query but it doesn't work. Says that "An expression of non-boolean type ... near "AND" I picked the Custom SQL Alert-Single Boolean Return as the type and left the default of "Use Repository Default" as the notification policy. I really have no idea why this isn't working. Got any ideas? SELECT CASE…

Thanks! And thanks to jaminsql. I'll be installing an update I've been putting off for a while. Now I have a reason. Thanks again.

Thanks, I would love to see if there is a way to change it.

1. SQL Server 2. Not sure what a super tab is. The regular graph in Resources doesn't show any blocked sessions for the day/week/month. But when I'm looking at current, I'll see several blocked sessions. (sorry, don't remember where I saw them). 3. yes, the chart is the one in resources.

gcp, We're just looking for rows inserted. This is just an alert to let us know that something is wrong. If this table hasn't had any input in over 15 minutes, something has gone wrong. Best, mh

I'm not even sure where to start with that. I guess I would try a Custom Alert - Single Boolean Return? I'm also unclear on the notification policy field. How does that work in a Boolean case? Thanks for taking the time to help on this.