Hi folks! I have an alert that fires on error 208(Invalid object name '%.*ls'.)
Can i customize it to get some thing like in the Net-Send command:
(invalid object name '%.*ls'. executed by %user from %computername)
What my concern here is to customize the messages. The description option in the alert allows only static info to be added.
Howdy!
Can you use the below query to get CPU high utilisation alert purposes for both named and default instance? or, do I need to make any changes here (@wmi_namespace=N'.ROOTCIMV2' ) ?
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'CPU_WM_Utilization_Check',
@message_id=0,
@severity=0,
[code]....
Hello Everyone,
Please help Newbie !!
I have a server where I have been getting
"SQL Alert Sev 24 : Fatal Error : Hardware Failure" for
the past week.
Occurence : We disconnected the workstation (which we are
using as SQL Server) from one floor and connected it to
another floor. No Configurations changed. No hardware
failures reported so far on the win 2000 box.
We are very well able to do the SQL development on that
box. Everything seems normal except I get this error sent
atleast once a day in the morning.
Regards,
Kurt
Follow are the Erros/Warnings in the Event log.
1)
The SNMP service is ignoring extension agent key
SOFTWAREMicrosoftDHCPMibAgentCurrentVersion
SOFTWAREMicrosoftWINSMibAgentCurrentVersion
SOFTWAREMicrosoftIASAgentCurrentVersion
SOFTWAREMicrosoftACSAgentCurrentVersion
because it is missing or misconfigured.
2)
Application popup. Service Control Manager : At least one
service or driver failed during
system startup. Use event viewer to examine the event log
for details.
3)
The site server ILS service service dependsd on the IIS
Admin Service which failed to start becasue of the
following error: The service cannot be started either
because it is disable or because it has no enabled devices
associated with it.
4)
The remote access connection manager service depends ont
eh Telephone service which failed to start because of the
following error: The service cannot be started, either
because it is disabled or because it has no enabled
devices associated with it.
5) Network Problem. The time service has not been able to synchronize with domain controller for a long time.
..
We are trying to create some alerts in our SQL Server 2014 BI edition.Issue is that, after I chose "Type" as "SQL Server performance condition alert" nothing is listed in the "Object" list box.SQL Server event alerts are working. Issue is only with "SQL Server performance condition alert".
View 3 Replies View RelatedWe recently had a problem with DB Mail. SQL jobs that sends an email succeeded but the email in the job fail to sent. There was a problem with the email server. The error is included. We fixed the problem with the email server. How can I get an alert when a DB Mail email fails send?
Date4/23/2015 10:01:06 AM
LogDatabase Mail (Database Mail Log)
Log ID5907
Process ID13204
Mail Item ID5702
Last Modified4/23/2015 10:01:06 AM
Last Modified Bysa
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-04-23T10:01:06). Exception Message: Cannot send mails to mail server. (Insufficient system storage. The server response was: 4.3.1 Unable to accept message because the server is out of disk space.).
)
How do I configure the database so that it will send an alert to all users who are logged in and using SQL*Server, when I need them all to get out of the database ??? Or, what do I need to look up in the documentation ??? I have looked under SQL*Mail, but that doesn't look like it will work for what I am trying to do.
Any help you can give me will be greatly appreciated.
Thanks,
Nancy
It seems that in order to get an email alert from SQL Server 2000 I need Microsoft Outlook orMicrosoft Exchange client installed. Is there any other way to get an email alert (not net send) when a back up is finished? for example using a @hotmail.com account?
thanks
I'm pretty new to MSSQL. We have SQL 2K and I was wondering if anyone has seen this issue before.
When I create/modify an Alert there is no option for "SQL Server Performance Condition Alert" in the Type under General tab.
Has anyone seen this before? What can I do to get this type of Alerts?
Just a note -- on my other SQL servers they have the options.
thanks in advance !
I have a SQL 2000 sp3 installation on a Active - Active
cluster. I wanted to create a performance alert, but when
I tried, the Sql Server Performance Condition Alert choice
is missing from the drop down menu on the new alert setup screen. Does anyone know why? Any help will be greatly
appreciated.:confused:
Hi
I am trying to setup alert msg. on my mobile phone when sql task fails
Has any body done this before????? Any sugessitions????
Thanks
Vijay
I am trying to create an alert when there are more than 2500 connections to our ailing SQL Server.However, for now, I need to restart the SQL server service because users begin complaining they can't connect.
1) I created an operator - me.
2) I created a job which runs a query.
INSERT INTO Sessions_alert
SELECT host_name, program_name, login_name, count(c.session_id ) num_sessions, getdate()
FROM sys.dm_exec_connections c JOIN sys.dm_exec_sessions s on c.session_id = s.session_id
GROUP BY host_name,program_name,login_name ORDER BY 4 DESC
3) I created an alert - included the job from above. Type performance condition alert. Object - SQL Server General Statistics. Counter - User connections.Alert if counter rises above 50. Just testing. I really want to know when it gets past 2500.
4) I've set the alert to email and delay is between responses 2 minutes.
It history tables says number of occurences is 18964. However, I don't receive an email.
Shouldn't the alert send an email? Do I need to include email code in the job?
I have a simple SSIS package that imports an Excel Spreadsheet into a table. The column heading got changed, so the package failed, as expected, but I would like an alert or some way to make the scheduled job show "failed". I tried putting an event handler on the :Data Flow" step to send an email, but it didn't work.
I would like to figure out the event handler problem, but more important to have the job show as failed.
For some reason the Scheduled job shows "success" even though the SSIS package failed. A better solution is to make the scheduled job itself fail, based on the package failing.
I've noticed that the 14150 event is no longer showing up in the Application Log. The 14151 event does. We tried modifying the alert:
sp_altermessage 14150, 'WITH_LOG', 'true';
But this of course doesn't work on messages under 50000. We utilized this alert in SQL 2000 to send emails upon the success of a merge replication. Any idea how to get this to work? Is there a workaround or did MS drop the ball on this event? If they dropped it - sure wish they would let us know and also remove the ability to setup the alert for it...
Thanks in advance!
-Dave
Same SQL Server DB engine (2012), connected with two different clients (2008 and 2012). When I check objects for performance condition alert, 2008 client shows the objects name with leading "SQL Server".But 2012 client displays just the object name and NOT prefixed with "SQL Server".we have automated alerts creation, so it fails depends on the client version.
View 0 Replies View Relatedi was trying to install sql server 2000 enterprise edition on win 2003 with SP1. i got stuck with this error sayinbg;"the driver software you are installing has not been properly signed with Autheticode(TM) technology. therefore windows cannot tell if the software has been modified since it was published. the publisher's identity cannot be verified because of a problem,
The installed INF file does not contain digital signature infromation"
Do you still want to install this driver software?
No matter what i click, either yes or no, it takes me nowhere. i googled it everywhere still could not find a solution. please let me know if you guys got any idea.
I have a Table "Customer" which contain a Field "CreditLimit",
Now I want a Mail alert on change of this filed with both value old credit limit value and New credit limit value.
Is its possible without trigger??
SQL Server 2014 BI edition.
select * from sys.dm_os_performance_counters returns the object names prefixed with "SQLServer:" (e.g. SQLServer:Databases)
It was expected as in other editions also. Issue is that when we try to crate "SQLServer Performance Condition alert", object names in "Object" list comes without the prefix "SQLServer:" (e.g. Databases). Please see the attached snapshots.
Folks, i want an alert to be displayed by SQL when the processor shoots above 80% constantly for 30 seconds. Is there any perfomance counter alert sepcifically for this purpose?
Howdy!
Hi there
I've created the new alert by going to use the following stored procedure:
EXEC msdb.dbo.sp_add_alert @name=N'Severity
19 Error',
@message_id=0,
@severity=19,
@enabled=1,
@delay_between_responses=180,
@include_event_description_in=7,
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
But the result has a strange characters between 'Severity' and '19 Error' in sysalerts column. So I can't even drop this by using sp_delete_alert.
My question is how to access and modify the sysalerts system table cause I don't think you can access system table anymore?
BTW ... I am using the 90.00.3042 (Sp2).
Thanks
Hi,
I have to generate an automatic mail alert based on the sql server database table.In that
table has expiry dates baed on that dates ,I have to send an automatic mail through sql server.
please give solution for this issue.
Thanks in advance.
Regards,
Raja.
I'm trying to develop a email alert feature on my project. I was trying to approach with SQL trigger wich I think is the best option. Basically, when a new record is inserted into ad table, a email alert goes to peolpe who selected to receive alert wehen certain conditions are met. What would be the best approach? any examples?Thanks
View 2 Replies View RelatedI have set up an alert to detect when Page Deadlocks rise above 0. Overnight I have DTS packages populating SQL Server and various other jobs (Cognos Cube Builds etc.). My alert detected a Deadlock during the night but all of my processes completed fine. My problem/misunderstanding is that my alert is still popping up every 5 mins saying there is a Deadlock yet there is nothing running or no-one accessing SQL server and I cannot see any trace of the Deadlock in the Current Activity. Is this normal or is it a bug?
View 1 Replies View RelatedI have two questions:
1) how can I get an alert (via paging or email) when the SQL server is down ?
2) how can I get an alert ( via paging or email) when the SQL Agent goes
down?
I'm a novice SQL Server DBA.
thanks!
Currently, my client is allowing all the developers to log in as sa and most servers have a NULL sa password. Not a good idea. I am recommending them to move to integrated security with NT groups and to move away from using the sa login altogether. Then to secure the sa login, actually give it a password (something cryptic). I also wanted to set up an alert whenever someone logs in using the sa password. How can that be accomplished? A trigger on the sysprocesses table would work but seems a little risky.
View 8 Replies View RelatedHello!
I've created an alert that is raised when the Percent Log Used rises above 80%. The response to this alert starts a job that performs a log backup.
Sometimes the database server is pretty loaded and the log backup takes some minutes and the alert is raised 3 (or more) times before the log backup ends. In response to this alert, plus 3 backups are performed.
Is it possible to make the alert sleep while the log backup is running, to avoid those extra backups?
I thought about disabling the alert in the first step (and re enabling it as the last step) but if the job fails the alert wouldn't be enabled... Right?
Thanks!
Fabio
I am trying to setup an alert when the following message occurs:
Stored function 'isxpf_execsql' in the library 'c:issrvinisxpf.dll' generated an access violation.
Error: 0, Severity: 20, State: 0
The Alert is defined as:
severity - 020
databasename: all databasese
error message contains this text: isxpf_execsql
This has occured sinde the alert was setup and the history of the alert says it has occured 0 times.
Any help would be appreciated.
TIA,
Philip
if in response to an alert i have defined a job and this job is scheduled for 10.00 am daily, will this job execute daily or only in response to the alert?
also i have set notifications to my computer in alert as well as in job. buti get notification defined in job and not in alert. why is it so?
Hi all,
I have encountered the following message while checking the Event Viewer of Administrative Tools (Common) :
SQL Executive Alert Engine
The data portion of event 19020 from MSSQL Server is invalid.
Is this serious or can I ignore it?
Anyone know what steps I should take?
Any advice will be much appreciated.
I am setting up alerts on a new installation of SQL 2000 (on windows 2000 op-sys). I have set up the operator for email and paging. When I test the email and paging notification at the operator level, it works fine. I have set up an alert for a user defined message to page and email the operator if the error is raised. The error writes successfully to the SQL Server log however, the page and email do not work. I have similar alerts set up on several SQL 7.0 installations. What am I missing? Any suggestions are greatly appreciated.
Thanks
tcb
Hi all,
We have encountered a major SQLServer 2000 bug. I would like to find out whether anyone has seen this or whether there are work around. We are using SQLServer 2000 Standard Edition running on Windows 2000 Server.
Here is the problem. We have a main SP that calls several long SPs (1000+ lines in each SP) to migrate data from one SQL2000 server to another SQL2000 server. (Both database servers are within the same PC.) The bug occurs in the main SP. It skips a specific SQL statement (which is a call to a SP). There is nothing unique about this SQL statement because the same statement in other parts of the same SP works. This bug occurs consistently. We were able to trace it by putting PRINT statements around this SQL statement and inside the calling SP. We also tried to trace it using the Query Analyzer's Debug with a strange behavior. It seems like the Debugger has a line shifted in it's memory (lines are displayed fine.) This shift occurs a few statements before the Problematic Line. We observe this by trying to put a break point on a valid SQL statement. But the red dot actually shows on a comment line right after the intended line. It does not Step Into the Problematic Line (which is a call to a SP). Note that when we run small SPs, this behavior
does not show up. Everything works fine for small SPs.
Any help is appreciated.
Chung.
I am working with alerts and trying to see if there is a way that I can control the message on the notification. I have the job set to send an email and a net message when the job succeeds. Since this message will be going to the user, I owuld like to be able to make the message as clear as possible for them. Does anyone know if the message being sent can be modified or altered with an alert? And how?
Thanks!!
I wish I could delete the SPAM from Jasel.
-PatP
Hi guys,
Hope you are all well.
I am trying to set up a 'SQL Server event alert' that will 'net send' a warning message to one of the Operators that have been set-up on our SQL Server.
The alert has been configured to act on severity level '009 - User Defined', for all databases.
I have created a user defined system message with a severity level '9' on the sysmessages table.
EXEC sp_addmessage 80000, 9, 'My User Defined Message'
...and I have raised this error on our SQL Server.
RAISERROR(80000, 9, 1) WITH LOG
The error message is being generated in the SQL Server Log file, but for some reason my Alert does not appear to fire off the 'net send' event.
The operator is 'available to receive notifications', and I have tested the 'net send' command successfully.
Does anyone know why this Alert might not be sending a message with the 'net send' command?
Thanks in advance,
Kevin