Morning all!
My SQL server email job notifications have stopped working, but mails sent through the xp_sendmail command still work.
The only thing that has changed recently is the SQL server agent account passwords have been changed, these accounts are normal win2000 domain accounts.
Any ideas cos I am fully stumped?
Is it possible to set up a Job to send a notification , if a process is blocked for more than a minute on SQL Server 2000.
Thanks for any help on this
I wish to know if there is anyway to find out if a perticular job on SQL Agent was executed or not. I am not looking for Log History of the job, but, something like a trigger that will fire an email to notify that a perticular job that was scheduled to run at a certain time did not run.
To explain in detail, I have a job that is scheduled to run every 15 min. This job is crutial and I wish to be notified if the job was not run for some reason or other. I already have a program that delivers me the history log of the job each day, but, checking history to see if the job ran or not every 15 min is not possible. Again, I am not talking about the job success or failure, but the fact that the job has run or not - thats it !
If you are suggesting a SMO object, I will appriciate if you provide me with the code or alternatively a source to refer.
Thank you.
hi all i have found for function as function: SubscriptionEnumeration in API of notification service, i want display myAlert(notifications) in(for example: one day).the Function SubscriptionEnumeration display Subscription of (subscriberId,subscriptionType,nsApplication) it can be made this ?thanksHungN
View 1 Replies View RelatedHi,
I want to build sql notification service in my web application and i not know how to build it. Please help me how it possible and any sample code then pls send me else give me link of website. Its very urgent for me, now i am using timer for checking for updation in database and i want to notification service for that because its take many time and timer fire every time even database change or not.
Jaydev Jangid
hi,
An application, every one hour it connects to sqlserver and uploads data from MSAccess database.i should get the notification weather that application is connected to the server or not.because this application gets currepts very often.
any help is appreciated.
thanks
preethi
Does anyone know how I can receive some type of notification (an alert) that fires when a new database is created (or an old one deleted) on a server?
Thanks.
I have set up SQL Mail on a SQL 7.0 box and I can successfully schedule tasks and receive e-mails from them. However, when I try to get mail notification from a scheduled DTS package I run into problems and no mail is sent. Under Profile Name the only item selectable is Microsoft Outlook. I've tried selecting this as well as leaving the profile blank and nothing seems to work. We use POP3 server and Microsoft Messaging. Our corporate e-mail system is Notes so we forward mail through the POP3 server via Internet mail to our Lotus Notes system.
Any suggestions so that we could get our DTS mail notification working? Anything I could try that I haven't?
Thanks!
Does anyone know if there is any software available that notifies specified people when an error above a certian level occurs. Im thinking along the lines of email and text message.
Im running sql server 2k at sp3a level, and the software will have to be compatible with it so as to get the event notification to pass the information on.
If there isn't any software, would anyone know of any scripts that will do this?
MSDE 2000? Thanks.
View 2 Replies View RelatedCan you send these to a group of DBA's
View 1 Replies View RelatedHow can I set up the notification email when one of your jobs got failed using Database mail..
I've already set up the database mail ... but I am not quite sure how to use the database mail to send a notification when a job failed...
Dear all,
I would like to know, is there any method that the notification can be send more than one person? (SQL server agent--> Job Properties--> Notification--> email)
The dropdownbox list allow one email only, can I add more people on the email list, or insert more email address in the same operator?
Thanks to all
johnson Mok
Hi,
Can anyone tell me abt SQL Notification Service ???
Is that SQL Programming application or can be implemented with other Dot Net Languagues ???
Need to know further that this services are implemented only by the Database Engineers or integrated with the Application development using .Net Language like C# etc ????
I m n urgent need for this problem
Thanks in advance
Regards
Aravind
Hi,
I have scheduled a job that runs every minute.
If the job does not succeed, then I would like my front end application to be notified.
I am not sure if this is a reasonable way but I am thinking of somehow
populating a table (Only if the scheduled job fails) in sql server and then read that table every minute from the front end application.
So, is it possible to populate a table if a job fails?
I do not see any options for this in the properties of the job.
Thanks
Hi all,I wanted SQL server to sent me an email when it reboots. I created an Alertbut doesn't seem to be working. Any suggestions.Thanks,
View 1 Replies View RelatedIs there any way to configure a notification icon in the start tray in Express 2005 (like we had in SQL Server 2000) with a little green (or red) arrow (or dot) to indicate whether the server's up (or down)?
View 3 Replies View Relatedi have a scheduled ssis package and because it's pretty critical i have to do a lot of error handling. inside the package all possible errors are handeld but now i have the question if there's a way to check whether a scheduled sql server job was started successfully or not. because if the job doesn't start i cannot get an error notification from inside the ssis package. in sql server management studio there's the possibility to send a notification if a job fails, but i don't know if this also includes the case when the job doesn't start at all.
View 4 Replies View Relatedhi i am getting the error for granting
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO sa
error is
Cannot find the user 'sa', because it does not exist or you do not have permission.
SO PLEASE GIVE ME THE CODING
step by step for notification
thanks
Hello,
I have a problem with the notification. I have enabled Database mail and i have created an Operator.
Under SQL Server AgentJobs and then in the job properties i have enabled notification but i don`t receive a mail. Test e-mail works fine but "real" e-mail not.
I have also tried with the Database Maintenance Wizard but even then it just not work.
I have noticed that others have experienced the same problem but i have seen no solution yet.
Could you please help me? What can cause this problem? What`s the best i can do to start searching for the solution? Thanks!
I need to set up an automatic email notification. Right now, I have a subscription that is working. The subscription runs a report and puts the resulting pdf into a folder. I need a way to notify users (preferrably in an Outlook distribution list) when the pdf is created. I'm amazed that this basic feature is not built into the subscription capabilities.
Can anyone please tell me how to best accomplish this? I'm familiar with vb.net if that helps.
Thank you very much.
i've scheduled a few ssis packages as sql server agent jobs. is there a way to get a daily notification via mail where all planned and all processed jobs are listed?
View 5 Replies View Related
Hi, looking for some help on job notification emails in SQL 2005.
I've created a backup job in the Maintenance Plan section of SQL2005, and added a "Notify Operator" task to notify me when the job completes.
I've setup Database Mail, and I am getting the notification email whenever I run the job. So this is working fine.
The problem is when I got to the 'Jobs' folder, and into the properties of my backup job, I set it up to notify me from the notifications option, but I am not getting any emails. For now I have set it to notify me when the job "succeeds".
Any ideas why it works from the Maintenance Plan section, but not the "Jobs" notification section? Am I forgetting something?
I have recently migrated a SQL2000 instance to SQL2005, and would now like to setup all the existing jobs to notify me if they fail.
Any advice would be helpful
Thanks
hi,
When SQL server notifies the application that the records in a table has changed, is there a way to know which record has changed from the application?
Let me give an eg.
Consider that we have a table customer. We have registered for a notfication for 2 customers, say Cust id 1 and Cust id 2. Now , when records for these two customers changes we get a notification. Is there a way in .Net by whihc we can get whihc customer has been modified?
Thanks
Man.
I am replicating using SQL Server 2000.
I have several merge agents which periodically fail due to locking contention. This is not a problem. The agent just runs again and is almost always successful, eventually.
I need a way to be alerted when the merge agent has failed three times consecutively.
Is there a way to do this?
hi to all,
my question is how can the database notify the user if there is a new inserted data on the database...like for example, i inserted a new data then when i go to the display reports page i would see a link saying New Report Recieved and this will take me to the details of the new inserted data or the report sent by another user..is this doable?? and by the way im using asp.net 2.0 and a sql database...thx...
Please Help!!
I have been trying to think of a solution to a problem i have and still not sure how to go about it.
I have a database filled with message data that is sent by one user to another.What i am trying to do is have it so (if users are online) they are notified - by a popup or something - that a new message has arrived for them.My idea was to create a trigger on the message table to update a change table with sender and recipient ids and date of change in it.Not a problem so far but what is troubling me is that i want the recipient to automatically query this change table every say 30 seconds to check if new message has arrived with their id.Tryed using ajax update panel and timer but naturally that kept posting back whole page - looks really terriable :( - tryed sqlnotification but as far as i can see that is only changing cached data for current data - not the same issue i think.Is there a way to query db table regualry without the client side knowing? - thinking along lines of how outlook requeries server for new messages and displays popup to say new message but doesnt interupt you if doing something else.Any help would be greatly appreaciated.Thanks
Hi,
I'm trying to install Sql server notification service on my pc, which has sql server 2000 and vs.net 2003 installed, but its telling me that I should have the .net framework installed before continuing the installation. The .net framework is already installed, any ideas why is it doing this????
Thanks
Hello, I'm trying to install sql notification service on my laptop, but its giving me an error saying that the .net framework should be installed. I have the .net framework 1.1 and vs.net 2003 installed. Any one have any ideas what would cause this??
View 1 Replies View RelatedHi All,
I am working on a client product that shrinks the database in MS SqlServer. After shrinking the database files, it does not send any email notification to the users.
My question is: Is there any way in SqlServer to sense that the database has been shrunk and send a notification to the users (may be through an Alert or a Job or something). Please let me know the steps to do that.
Thanks
Sri
Is there a way for an automated job to e-mail or net send to multiple locations on failure or completion?
View 3 Replies View RelatedHi!
I had configured SQL Agent and SQL Mail to use the profile that I created by logging in as the SQL Agent domain admin. service account. The mail service was successfully working. Now, when I create an operator with my mail account and test it, Agent gives the message that the mail was successfully sent, but I don't actually receive any mail.
Why could this happen? How can it be fixed?
Praveena
We’re creating a program and need some advice about locking. The program will select data for the user to view; the user may or may not then perform an update on the set. There exists a possibility of another user attempting the same operation at the same time. Thus we want to have the first user lock the data set and the second to be able to select only until the first is complete. We’ve run some tests using the UPDLOCK hint. It works as expect except for the blocking. If a connection attempts to create another Update Lock after another connection has one, then the new connection is blocked. We’re looking for a way to let the program know that an update lock is in existence before it tries to create a new one. The sp_lock procedure can display all the locks, but you can not select specific values (i.e. select any update locks on ObjectID = x). Do any of you know another way or how we can use sp_lock for our purpose?
Thanks in advance.