Showing posts with label occurs. Show all posts
Showing posts with label occurs. Show all posts

Sunday, March 25, 2012

alerts subscription is throwsing an error


http://forums.microsoft.com/MSDN/alertsSignup.aspx?PostID=1482020&IsThread=True&SiteID=1

404 error occurs

You can log all the forums specific bugs & issues at

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=53&SiteID=1

sql

Alerts not firing off jobs.

sql2k
sp3
Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
checked to fire off a job when it occurs. I then generate a deadlock, but the
job never gets fired off. Some important fun facts:
1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
2; I've tried running different jobs manually. They both work.Is the alert itself firing? Make sure that the EventLog
service and SQL Agent are running. Check the Event log to
make sure that it is not full. Check if the event is writing
to the Application log. There is also a topic in books
online with more information on troubleshooting alerts.
Check the topic: Troubleshooting Alerts
-Sue
On Thu, 13 Apr 2006 15:36:02 -0700, ChrisR
<ChrisR@.discussions.microsoft.com> wrote:
>sql2k
>sp3
>Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
>checked to fire off a job when it occurs. I then generate a deadlock, but the
>job never gets fired off. Some important fun facts:
>1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
>2; I've tried running different jobs manually. They both work.
>

Alerts not firing off jobs.

sql2k
sp3
Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
checked to fire off a job when it occurs. I then generate a deadlock, but th
e
job never gets fired off. Some important fun facts:
1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
2; I've tried running different jobs manually. They both work.Is the alert itself firing? Make sure that the EventLog
service and SQL Agent are running. Check the Event log to
make sure that it is not full. Check if the event is writing
to the Application log. There is also a topic in books
online with more information on troubleshooting alerts.
Check the topic: Troubleshooting Alerts
-Sue
On Thu, 13 Apr 2006 15:36:02 -0700, ChrisR
<ChrisR@.discussions.microsoft.com> wrote:

>sql2k
>sp3
>Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
>checked to fire off a job when it occurs. I then generate a deadlock, but t
he
>job never gets fired off. Some important fun facts:
>1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
>2; I've tried running different jobs manually. They both work.
>

Thursday, March 22, 2012

Alert for Replication-Conflicts

Hi, I need to set an alert when a replication-conflict occurs rather that to check for conflicts manually. How can i accomplish this? I couldn't find the particular error-message to trap in an alert.
Regards!!Check your question for reply on other forum (SQL performance).

Tuesday, March 20, 2012

Alert for Conflicts

Hi,
Is it possible to be notified whenever a conflict occurs during merge sync?
With a mechanism like alerts.
Thanks in advance,
Leila
You can use the interactive resolve in conjunction with Windows
Synchronization Manager.
Other than that you have to poll the tables for this.
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:udATMJkJIHA.4684@.TK2MSFTNGP06.phx.gbl...
> Hi,
> Is it possible to be notified whenever a conflict occurs during merge
> sync? With a mechanism like alerts.
> Thanks in advance,
> Leila
>