Hi,
>>
-Create the desired alerts in Enterprise Manager. For each alert, specify the operator(s) you want to be notified.
Run the client (DbMAlerterClient.exe) to create the needed tables in msdb, and also configure the SMTP mail settings.
-Schedule the server (DbMAlerterServer.exe), which will read the eventlog and submit email to the operators as configured. -Recommended scheduling interval is between once per minute to once per 10 minutes. DbMAlerterServer.exe will attempt to login to the SQL Server using Windows logins and it takes one command-line parameter: the name of the SQL Server to connect to, as in
<<
1. does this mean after configuring DbMAlerterClient.exe we do not close it and add it to start up ? does this goes the same for DbMAlerterServer.exe ? Please kindly assist
C:\Program Files\DbMaintSmtpAlerter\D
2. what is instanceName ?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
it is very simple explanation - step-by-step :
http://www.karaszi.com/sql
---
instance - sql server 2k name
---
MS DOS command line that can be executed as scheduled task :
run for your DbMAlerterServer.exe location
below it is example:
\Program Files\DbMaintSmtpAlerter\D
"do we place this with .exe ? My apology for being lost on this.
C:\Program Files\DbMaintSmtpAlerter\D
yes, that looks correct based on the instructions above.
To use a SQL Agent job instead of the Windows task scheduler, you would need to call xp_cmdshell and execute the same application and again provide the sql server name lclSQLsev
EugeneZ,
Yes ofcourse,
1. created the operator
2. added the operator to the existing jobs (db backup etc).
3. set notification on complete.
4. run client.exe created the table as per client, then configured the smtp , to, from. (left open) should we close this?
5. send a test mail, was able to received.
6. sceduled using windows scheduler.
"C:\Program Files\DbMaintSmtpAlerter\D
run as administrator.
I could be missing something, I've read it's going to fill up a table? or reading the error logs?
maybe we can check if there are any error generated? not sure how to troubleshoot next
Thanks.
check limitations from:
http://www.karaszi.com/sql
What I did for testing:
added new alert - 15298 - New login created - open it - checked: Always write in Windows eventlog
- checked operator (my self)
Added job: Alerter:
step1 -
selected type:
Operating System command:
paste
command
C:\Program Files\DbMaintSmtpAlerter\D
--it is my file location
Schedule it for every 15 min
-------------
now:
Create test login- and manually (for test) run the alerter job
I did it - it is working ok
I created stored proc -
--in pubs db
create proc dbo.usp_test
as
select * from somenotrealTable
---
create job
as step1:
exec pubs.dbo.usp_test
---
then ran it - job failed but alert was triggered and sent me email (just do not forget check alll above:
eventviewer, check box to who send notification..
When I replace the alert number to 15298 (new user created)
everything is good (i get the email)
SQL Server error text:
======================
Error: 15298, Severity: 0, State: 1
New login created.
but when I place alert no. 208 it doesn't send..
weird, I can see in event viewer that they are being generated...
What alert no did you use?
Thanks.
I've done it now,
When I add alert 208
and run the email notification job (server.exe hostname)
the following error occurs:
Executed as user: SQLTEST\Administrator. Error from .Net SqlClient Data Provider: Line 12: Incorrect syntax near 'asdqwe'. Process Exit Code -1. The step failed.
but when I remove event ID 208 everything works, even tried create a new alter 208 , seems something is wrong.
Thanks.
yes, it does work for 15298, perfectly.
sadly i think i've inputed the value asdqwe somewhere, i could find it again...
when I add 208 sending notification job fails..:
Executed as user: SQLTEST\Administrator. Error from .Net SqlClient Data Provider: Line 12: Incorrect syntax near 'asdqwe'. Process Exit Code -1. The step failed.
EugeneZ,
The job (sending email notification) always fails because "asdqwe" was the bogus table. What could I have done wrongly ? :(
create proc sp_test
as
select count(*) from asdqwe
GO
the following error occurs:
Executed as user: SQLTEST\Administrator. Error from .Net SqlClient Data Provider: Line 12: Incorrect syntax near 'asdqwe'. Process Exit Code -1. The step failed.
Thanks.
Business Accounts
Answer for Membership
by: Kevin3NFPosted on 2005-10-06 at 07:24:30ID: 15030741
Instance name is only relevant if you have installed SQL Server as a named instance. If you chose to install SQL Server as a default, just use the SQL Server name
I have no idea what DbMAlerterClient.exe is...is that a third party application?