SQL Server Notification Services announcement
-
Link
The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.
Please use http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.
Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.(Attribution: Jang-uk In)
Hope that helps,
-Lukasz
-
0 VotesMSSSPI-101: [LOG] Unable to read local eventlog (reason: The event log file has changed between read operations).
Hi all, I need help from your clever brains. I have problem with this issue: MSSSPI-101: [LOG] Unable to read local eventlog (reason: The event ...
-
0 Votes
Detect SqlNotificationRequest failure in .Net?
Periodically SqlNotificationRequest fails to register a SQL query notification subscription (sys.dm_qn_subscriptions is an empty set). There doesn't appear to be a way to look up the UserData in ... -
0 Votes
Sending the user with Active Directory account the detailed error message
How do I send the user detailed error message from sqlserver job? This user has an ad account in sqlserver and Notification has her name. But she receives an email with summary only but not ... -
1 Votes
Database Mail Profile is not displayed when configuring Notification for a job.
I created a profile and account using the Database Mail wizard. I successfully sent and received a test email after setting it up. I then configured SQL Server Agent to use DB Mail and verified ...Answered | 7 Replies | 4601 Views | Created by FredHue - Wednesday, February 24, 2016 4:43 AM | Last reply by scott_morris-ga - Monday, April 29, 2019 3:57 PM -
1 Votes
Notification that a JOB did not start in SQL Server Agent
Is there a way to send an email alert notification when a job just didn't run? The job just didn't run so there is no failure or success.Proposed | 1 Replies | 1185 Views | Created by Charlie2 - Wednesday, April 17, 2019 2:37 PM | Last reply by Olaf Helper - Thursday, April 18, 2019 6:28 AM -
0 Votes
Unable to get SQLDependency to work as expected
Hi Folks, I have a simple console application (C#) for which I am trying to set up a notification system using SQLDependency. This issue is as soon ...Answered | 1 Replies | 1310 Views | Created by AndyW2007 - Thursday, March 14, 2019 2:09 AM | Last reply by AndyW2007 - Thursday, March 14, 2019 3:26 AM -
0 Votes
AlwayOn Monitoring via Alerts - Getting Lots of Emails
Hello, I have recently setup AlwaysOn in SQL Server 2017 and has been in Production for several weeks now. Everything is working fine. I'm currently ...Unanswered | 3 Replies | 1418 Views | Created by Sidney L - Tuesday, February 12, 2019 2:34 PM | Last reply by Mohsin_A_Khan - Tuesday, February 12, 2019 5:05 PM -
0 Votes
Two operators for one job
Hi, I have a SQL Server Agent job. If the job fails one email address must get a notifications. Not problem with that. But, another email address must get a ...Unanswered | 1 Replies | 1423 Views | Created by dktoa - Friday, February 1, 2019 1:53 PM | Last reply by Olaf Helper - Friday, February 1, 2019 2:06 PM -
0 Votes
SQL Timeout period elapsed error
Hello All, I have gotten an error today that has been going on since 8 AM this morning. The error is pointing to a timeout elapsed prior to completion of the operation or the server ...Unanswered | 1 Replies | 1641 Views | Created by Jeff at Frank - Wednesday, January 30, 2019 10:39 PM | Last reply by Olaf Helper - Thursday, January 31, 2019 7:34 AM -
0 Votes
Creating Automatic Robot or something like Crawler
My problem is that in Local SQL Server(2016, Not Asure), I have a table which people can request what type of house they want to buy. On the other hand, there's another table for different ...Unanswered | 1 Replies | 1619 Views | Created by Mohammad Amin(Iran) - Monday, December 24, 2018 11:35 AM | Last reply by ComputerScott - Thursday, December 27, 2018 8:28 PM -
0 Votes
Send an alert without SMTS server
Hello, We have few jobs configured for autogrowth, memory and cpu spike, blockage as per the client requirement. But, we don't have SMTP server so, we can't configure database ...Unanswered | 2 Replies | 1680 Views | Created by Chickoo79 - Wednesday, November 28, 2018 4:13 PM | Last reply by Visakh16 - Thursday, November 29, 2018 7:24 AM -
0 Votes
Send the email on the status of the SQL Server Performance
Hi Team, I need to send the report of each database and its performance at the end of the day. how to automate this?Unanswered | 1 Replies | 1649 Views | Created by Ideas12345 - Wednesday, November 21, 2018 12:52 AM | Last reply by Olaf Helper - Wednesday, November 21, 2018 7:08 AM -
0 Votes
SQL event logs wipes out after restart
Hi, Recently we had the issue where we could not connect to SQL server due to blocking. As we were not able to connect, we had to restart the SQL service. But as we restarted the ...Unanswered | 1 Replies | 1770 Views | Created by Kaps84 - Wednesday, October 24, 2018 9:22 AM | Last reply by ShabSQL - Wednesday, October 24, 2018 9:36 AM -
0 Votes
Alert message content with query result
Hi all, i set an alert to notify our team via mail in case of a mirror database state change. I set a WMI event alert with this query: SELECT * FROM ...Proposed | 5 Replies | 1770 Views | Created by DandiTV - Monday, October 22, 2018 9:16 AM | Last reply by DandiTV - Monday, October 22, 2018 1:48 PM -
0 Votes
Database Mail Error
We are recieving a bunch of database mail failed messages from a job that no longer exists. We had a job set up about a year ago to send blocking alerts but we disabled and deleted that job. ...Unanswered | 1 Replies | 1900 Views | Created by iojunta - Friday, September 21, 2018 5:45 PM | Last reply by Visakh16 - Friday, September 21, 2018 7:22 PM -
0 Votes
Office 365 and SQL reports: Failure sending mail: the remote certificate is invalid according to the validation procedure. mail will not be resent
Has anyone been able to get this to work? We recently migrated to office 365 from an onsite 2010 Exchange and the reports no longer ... -
0 Votes
Mail Queued after a SqlAgent Error
Hey guys in our company we have an issue with out Mail Database Procedure since 28th of August all the mails that we are trying to send from a certain email adress are not delivering to our ...Answered | 10 Replies | 1996 Views | Created by Mariano D - Wednesday, September 5, 2018 7:36 PM | Last reply by Mariano D - Thursday, September 6, 2018 1:53 PM -
0 Votes
Alert when database created or deleted
I am new to SQL, and I am trying to create an alert to e-mail an operator when a database is created or deleted. Does anyone have a script to set this up. Kurt KurtAnswered | 3 Replies | 14423 Views | Created by Kurt Woodfin - Wednesday, December 17, 2008 3:25 PM | Last reply by Mohsin_A_Khan - Saturday, August 11, 2018 3:34 PM -
0 Votes
Database mail issue
Greetings... Database mail has stopped working suddenly<g class="gr_ gr_103 gr-alert gr_gramm gr_inline_cards gr_run_anim Style replaceWithoutSep" ...Proposed | 2 Replies | 2073 Views | Created by WatchmanX - Friday, August 3, 2018 8:39 PM | Last reply by Mohsin_A_Khan - Friday, August 3, 2018 10:00 PM -
0 Votes
SQL 2016 Database Mail breaks after SP1 CU1 without .net 3.5
I have read quite a bit about this issue and thought I would add this. We had the issue of database mail not working with RTM install. Added the databasemail.exe.config file workaround and mail was ...Answered | 5 Replies | 4035 Views | Created by Mark Hood - Friday, January 27, 2017 4:01 PM | Last reply by SQLSlacker - Friday, July 13, 2018 4:36 PM - Items 1 to 20 of 851 Next ›
SQL Server Notification Services announcement
-
Link
The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.
Please use http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.
Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.(Attribution: Jang-uk In)
Hope that helps,
-Lukasz
