Alert setup

I setup Outlook to use a POP3 client. I can send and
recieve mail no problem. I can even open up SQL Server
Agent and define it to use the mail profile I setup and it
start and stops the MAPI session no problem. I define an
operator and click test it says it sent it successfully
however I don't get the message. When I stop the agent and
open Outlook 2000 I get this:
Your message did not reach some or all of the intended
recipients.
Subject: Microsoft SQL Server Alert System Test
Sent: 7/20/2004 6:47 PM
The following recipient(s) could not be reached:
'me@.mycompany.com' on 7/20/2004 6:47 PM
No transport provider was available for
delivery to this recipient.
Does anyone know what is the problem here. I can still
send email to myself from this account.Hi
You can try to log on to the server with the account that runs
Outlook/SQLAgent/SQLServer and then delete the Outlook profile. Then try
setting up a new profile. Sometimes a profile gets corrupted thus causing
strange errors.
I've come across this problem once in a while over the years when an
external program are trying to send an email via Outlook. I've never really
found the definate solution or work around - usualy it has been a bit of
playing around.You should also check that you have setup your mail account
correctly i.e. dosen't have any options that has to be chosen by the user
when sending an email.
I also think that I once read that Outlook needs Outlook Express to be
installed - otherwise you can get this error message. I think this was an
issue with Outlook2000 but I don't know if it's still the case with newer
versions.
Regards
Steen
"adba" <anonymous@.discussions.microsoft.com> skrev i en meddelelse
news:0f6e01c46ec5$7e99ae30$a501280a@.phx.gbl...
> I setup Outlook to use a POP3 client. I can send and
> recieve mail no problem. I can even open up SQL Server
> Agent and define it to use the mail profile I setup and it
> start and stops the MAPI session no problem. I define an
> operator and click test it says it sent it successfully
> however I don't get the message. When I stop the agent and
> open Outlook 2000 I get this:
> Your message did not reach some or all of the intended
> recipients.
> Subject: Microsoft SQL Server Alert System Test
> Sent: 7/20/2004 6:47 PM
> The following recipient(s) could not be reached:
> 'me@.mycompany.com' on 7/20/2004 6:47 PM
> No transport provider was available for
> delivery to this recipient.
> Does anyone know what is the problem here. I can still
> send email to myself from this account.

Alert on deadlock

I have created an SQL Agent Alert which should notify me whenever
a deadlock is occured on sql server. The following are the details:

Type : Performance Condition Alert
Object : SQLServerLocks
Counter : Number of deadlocks/sec
Instance: Database
Alert : If counter value rises above 0

I got deadlock situation a couple of times on server but i have never received any notification. It seems this settings doenot work. Pls. advise!

Thanks

Is the SQL Agent definitely running ?

If so, "Test" that that the SQL Agent can create a mail session. Right click SQL Server Agent, choose Properties, click the test button.

|||yes. Nothing wrong with sql agent. as such i get other alerts but not this one.|||Is the occurrence count still zero ?
Under the Response tab try reducing the "delay between responses". I recall reading somewhere that if at the time SQL samples the counters there may well not be a deadlock. i.e. the delay between responses is sufficiently high for the condition to disappear before SQL samples the data.

Alert fails to notify Operator (SQL Server 2005)

I am trying to set up a new alert which will notify me when a particular
error is raised. I have configured the SQL Server Agent Alert System to use
Database Mail, and confirmed that this works with Job notifications (I have
successfully notified myself by email on completion of a job).
I have added a new user-defined error with sp_addmessage and have created an
alert to notify me when this error is raised. I have then generated the erro
r
with the raiserror statement. The error message is returned in the query
result window, but I do not get the email.Hi Jon
"Jon Ley" wrote:

> I am trying to set up a new alert which will notify me when a particular
> error is raised. I have configured the SQL Server Agent Alert System to us
e
> Database Mail, and confirmed that this works with Job notifications (I hav
e
> successfully notified myself by email on completion of a job).
> I have added a new user-defined error with sp_addmessage and have created
an
> alert to notify me when this error is raised. I have then generated the er
ror
> with the raiserror statement. The error message is returned in the query
> result window, but I do not get the email.
Is there anything in the SQL Server error log?
If you have email blocking as part of the antivirus suite you may have
exceptions logged there.
John|||How did you define the alert notification? By error number?
TheSQLGuru
President
Indicium Resources, Inc.
"Jon Ley" <JonLey@.discussions.microsoft.com> wrote in message
news:29B92338-9259-489C-BFBA-C3D75B72B901@.microsoft.com...
>I am trying to set up a new alert which will notify me when a particular
> error is raised. I have configured the SQL Server Agent Alert System to
> use
> Database Mail, and confirmed that this works with Job notifications (I
> have
> successfully notified myself by email on completion of a job).
> I have added a new user-defined error with sp_addmessage and have created
> an
> alert to notify me when this error is raised. I have then generated the
> error
> with the raiserror statement. The error message is returned in the query
> result window, but I do not get the email.|||On May 19, 1:18 pm, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> How did you define the alert notification? By error number?
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Jon Ley" <Jon...@.discussions.microsoft.com> wrote in message
> news:29B92338-9259-489C-BFBA-C3D75B72B901@.microsoft.com...
>
>
>
> - Show quoted text -
Are you on service pak 2? There are problems with database mail that
are corrected with service SP2.
Worth a shot anyway.
Kristina|||John,
Thanks for your response. There does not appear to be anything in the error
log.
Jon.
"John Bell" wrote:

> Hi Jon
> "Jon Ley" wrote:
>
> Is there anything in the SQL Server error log?
> If you have email blocking as part of the antivirus suite you may have
> exceptions logged there.
> John|||TheSQLGuru: Yes, I defined the alert notification by error number (50001)
Kristina: I have just applied sp2 and retried. Still not working.
Regards,
Jon.
"Kristina" wrote:

> On May 19, 1:18 pm, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> Are you on service pak 2? There are problems with database mail that
> are corrected with service SP2.
> Worth a shot anyway.
> Kristina
>|||Hi Jon
"Jon Ley" wrote:

> John,
> Thanks for your response. There does not appear to be anything in the erro
r
> log.
> Jon.
>
Under the Alert Properties, there is a history dialog which should show you
if the alert has been triggered. If this is not updated when you cause the
error then you are not satisfying the criteria described in the remarks
section of http://msdn2.microsoft.com/en-us/library/ms189531.aspx. Check tha
t
the errors appears in the windows event log.
John|||Thanks, John, I have got it working now using the WITH LOG option on the
RAISERROR statement. This appears to be a change from SQL Server 2000 - I ha
d
exactly the same alert configured with a severity level of 10 and without it
being logged, and it would quite happily notify me by email when this error
was raised.
Regards,
Jon Ley.
"John Bell" wrote:

> Hi Jon
> "Jon Ley" wrote:
>
> Under the Alert Properties, there is a history dialog which should show yo
u
> if the alert has been triggered. If this is not updated when you cause the
> error then you are not satisfying the criteria described in the remarks
> section of http://msdn2.microsoft.com/en-us/library/ms189531.aspx. Check t
hat
> the errors appears in the windows event log.
> John|||Did you configure the alert to always log to windows eventlog? You can check
this in sys.messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jon Ley" <JonLey@.discussions.microsoft.com> wrote in message
news:54D9247D-1915-41DB-AA98-09D1E1E7B4DF@.microsoft.com...[vbcol=seagreen]
> Thanks, John, I have got it working now using the WITH LOG option on the
> RAISERROR statement. This appears to be a change from SQL Server 2000 - I
had
> exactly the same alert configured with a severity level of 10 and without
it
> being logged, and it would quite happily notify me by email when this erro
r
> was raised.
> Regards,
> Jon Ley.
> "John Bell" wrote:
>

Alert fails to notify Operator (SQL Server 2005)

I am trying to set up a new alert which will notify me when a particular
error is raised. I have configured the SQL Server Agent Alert System to use
Database Mail, and confirmed that this works with Job notifications (I have
successfully notified myself by email on completion of a job).
I have added a new user-defined error with sp_addmessage and have created an
alert to notify me when this error is raised. I have then generated the error
with the raiserror statement. The error message is returned in the query
result window, but I do not get the email.
Hi Jon
"Jon Ley" wrote:

> I am trying to set up a new alert which will notify me when a particular
> error is raised. I have configured the SQL Server Agent Alert System to use
> Database Mail, and confirmed that this works with Job notifications (I have
> successfully notified myself by email on completion of a job).
> I have added a new user-defined error with sp_addmessage and have created an
> alert to notify me when this error is raised. I have then generated the error
> with the raiserror statement. The error message is returned in the query
> result window, but I do not get the email.
Is there anything in the SQL Server error log?
If you have email blocking as part of the antivirus suite you may have
exceptions logged there.
John
|||How did you define the alert notification? By error number?
TheSQLGuru
President
Indicium Resources, Inc.
"Jon Ley" <JonLey@.discussions.microsoft.com> wrote in message
news:29B92338-9259-489C-BFBA-C3D75B72B901@.microsoft.com...
>I am trying to set up a new alert which will notify me when a particular
> error is raised. I have configured the SQL Server Agent Alert System to
> use
> Database Mail, and confirmed that this works with Job notifications (I
> have
> successfully notified myself by email on completion of a job).
> I have added a new user-defined error with sp_addmessage and have created
> an
> alert to notify me when this error is raised. I have then generated the
> error
> with the raiserror statement. The error message is returned in the query
> result window, but I do not get the email.
|||On May 19, 1:18 pm, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> How did you define the alert notification? By error number?
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Jon Ley" <Jon...@.discussions.microsoft.com> wrote in message
> news:29B92338-9259-489C-BFBA-C3D75B72B901@.microsoft.com...
>
>
> - Show quoted text -
Are you on service pak 2? There are problems with database mail that
are corrected with service SP2.
Worth a shot anyway.
Kristina
|||John,
Thanks for your response. There does not appear to be anything in the error
log.
Jon.
"John Bell" wrote:

> Hi Jon
> "Jon Ley" wrote:
>
> Is there anything in the SQL Server error log?
> If you have email blocking as part of the antivirus suite you may have
> exceptions logged there.
> John
|||TheSQLGuru: Yes, I defined the alert notification by error number (50001)
Kristina: I have just applied sp2 and retried. Still not working.
Regards,
Jon.
"Kristina" wrote:

> On May 19, 1:18 pm, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> Are you on service pak 2? There are problems with database mail that
> are corrected with service SP2.
> Worth a shot anyway.
> Kristina
>
|||Hi Jon
"Jon Ley" wrote:

> John,
> Thanks for your response. There does not appear to be anything in the error
> log.
> Jon.
>
Under the Alert Properties, there is a history dialog which should show you
if the alert has been triggered. If this is not updated when you cause the
error then you are not satisfying the criteria described in the remarks
section of http://msdn2.microsoft.com/en-us/library/ms189531.aspx. Check that
the errors appears in the windows event log.
John
|||Thanks, John, I have got it working now using the WITH LOG option on the
RAISERROR statement. This appears to be a change from SQL Server 2000 - I had
exactly the same alert configured with a severity level of 10 and without it
being logged, and it would quite happily notify me by email when this error
was raised.
Regards,
Jon Ley.
"John Bell" wrote:

> Hi Jon
> "Jon Ley" wrote:
> Under the Alert Properties, there is a history dialog which should show you
> if the alert has been triggered. If this is not updated when you cause the
> error then you are not satisfying the criteria described in the remarks
> section of http://msdn2.microsoft.com/en-us/library/ms189531.aspx. Check that
> the errors appears in the windows event log.
> John
|||Did you configure the alert to always log to windows eventlog? You can check this in sys.messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jon Ley" <JonLey@.discussions.microsoft.com> wrote in message
news:54D9247D-1915-41DB-AA98-09D1E1E7B4DF@.microsoft.com...[vbcol=seagreen]
> Thanks, John, I have got it working now using the WITH LOG option on the
> RAISERROR statement. This appears to be a change from SQL Server 2000 - I had
> exactly the same alert configured with a severity level of 10 and without it
> being logged, and it would quite happily notify me by email when this error
> was raised.
> Regards,
> Jon Ley.
> "John Bell" wrote:

Alert fails to notify Operator (SQL Server 2005)

I am trying to set up a new alert which will notify me when a particular
error is raised. I have configured the SQL Server Agent Alert System to use
Database Mail, and confirmed that this works with Job notifications (I have
successfully notified myself by email on completion of a job).
I have added a new user-defined error with sp_addmessage and have created an
alert to notify me when this error is raised. I have then generated the error
with the raiserror statement. The error message is returned in the query
result window, but I do not get the email.Hi Jon
"Jon Ley" wrote:
> I am trying to set up a new alert which will notify me when a particular
> error is raised. I have configured the SQL Server Agent Alert System to use
> Database Mail, and confirmed that this works with Job notifications (I have
> successfully notified myself by email on completion of a job).
> I have added a new user-defined error with sp_addmessage and have created an
> alert to notify me when this error is raised. I have then generated the error
> with the raiserror statement. The error message is returned in the query
> result window, but I do not get the email.
Is there anything in the SQL Server error log?
If you have email blocking as part of the antivirus suite you may have
exceptions logged there.
John|||How did you define the alert notification? By error number?
--
TheSQLGuru
President
Indicium Resources, Inc.
"Jon Ley" <JonLey@.discussions.microsoft.com> wrote in message
news:29B92338-9259-489C-BFBA-C3D75B72B901@.microsoft.com...
>I am trying to set up a new alert which will notify me when a particular
> error is raised. I have configured the SQL Server Agent Alert System to
> use
> Database Mail, and confirmed that this works with Job notifications (I
> have
> successfully notified myself by email on completion of a job).
> I have added a new user-defined error with sp_addmessage and have created
> an
> alert to notify me when this error is raised. I have then generated the
> error
> with the raiserror statement. The error message is returned in the query
> result window, but I do not get the email.|||On May 19, 1:18 pm, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> How did you define the alert notification? By error number?
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Jon Ley" <Jon...@.discussions.microsoft.com> wrote in message
> news:29B92338-9259-489C-BFBA-C3D75B72B901@.microsoft.com...
>
> >I am trying to set up a new alert which will notify me when a particular
> > error is raised. I have configured the SQL Server Agent Alert System to
> > use
> > Database Mail, and confirmed that this works with Job notifications (I
> > have
> > successfully notified myself by email on completion of a job).
> > I have added a new user-defined error with sp_addmessage and have created
> > an
> > alert to notify me when this error is raised. I have then generated the
> > error
> > with the raiserror statement. The error message is returned in the query
> > result window, but I do not get the email.- Hide quoted text -
> - Show quoted text -
Are you on service pak 2? There are problems with database mail that
are corrected with service SP2.
Worth a shot anyway.
Kristina|||John,
Thanks for your response. There does not appear to be anything in the error
log.
Jon.
"John Bell" wrote:
> Hi Jon
> "Jon Ley" wrote:
> > I am trying to set up a new alert which will notify me when a particular
> > error is raised. I have configured the SQL Server Agent Alert System to use
> > Database Mail, and confirmed that this works with Job notifications (I have
> > successfully notified myself by email on completion of a job).
> >
> > I have added a new user-defined error with sp_addmessage and have created an
> > alert to notify me when this error is raised. I have then generated the error
> > with the raiserror statement. The error message is returned in the query
> > result window, but I do not get the email.
> Is there anything in the SQL Server error log?
> If you have email blocking as part of the antivirus suite you may have
> exceptions logged there.
> John|||TheSQLGuru: Yes, I defined the alert notification by error number (50001)
Kristina: I have just applied sp2 and retried. Still not working.
Regards,
Jon.
"Kristina" wrote:
> On May 19, 1:18 pm, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> > How did you define the alert notification? By error number?
> >
> > --
> > TheSQLGuru
> > President
> > Indicium Resources, Inc.
> >
> > "Jon Ley" <Jon...@.discussions.microsoft.com> wrote in message
> >
> > news:29B92338-9259-489C-BFBA-C3D75B72B901@.microsoft.com...
> >
> >
> >
> > >I am trying to set up a new alert which will notify me when a particular
> > > error is raised. I have configured the SQL Server Agent Alert System to
> > > use
> > > Database Mail, and confirmed that this works with Job notifications (I
> > > have
> > > successfully notified myself by email on completion of a job).
> >
> > > I have added a new user-defined error with sp_addmessage and have created
> > > an
> > > alert to notify me when this error is raised. I have then generated the
> > > error
> > > with the raiserror statement. The error message is returned in the query
> > > result window, but I do not get the email.- Hide quoted text -
> >
> > - Show quoted text -
> Are you on service pak 2? There are problems with database mail that
> are corrected with service SP2.
> Worth a shot anyway.
> Kristina
>|||Hi Jon
"Jon Ley" wrote:
> John,
> Thanks for your response. There does not appear to be anything in the error
> log.
> Jon.
>
Under the Alert Properties, there is a history dialog which should show you
if the alert has been triggered. If this is not updated when you cause the
error then you are not satisfying the criteria described in the remarks
section of http://msdn2.microsoft.com/en-us/library/ms189531.aspx. Check that
the errors appears in the windows event log.
John|||Thanks, John, I have got it working now using the WITH LOG option on the
RAISERROR statement. This appears to be a change from SQL Server 2000 - I had
exactly the same alert configured with a severity level of 10 and without it
being logged, and it would quite happily notify me by email when this error
was raised.
Regards,
Jon Ley.
"John Bell" wrote:
> Hi Jon
> "Jon Ley" wrote:
> > John,
> >
> > Thanks for your response. There does not appear to be anything in the error
> > log.
> >
> > Jon.
> >
> Under the Alert Properties, there is a history dialog which should show you
> if the alert has been triggered. If this is not updated when you cause the
> error then you are not satisfying the criteria described in the remarks
> section of http://msdn2.microsoft.com/en-us/library/ms189531.aspx. Check that
> the errors appears in the windows event log.
> John|||Did you configure the alert to always log to windows eventlog? You can check this in sys.messages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jon Ley" <JonLey@.discussions.microsoft.com> wrote in message
news:54D9247D-1915-41DB-AA98-09D1E1E7B4DF@.microsoft.com...
> Thanks, John, I have got it working now using the WITH LOG option on the
> RAISERROR statement. This appears to be a change from SQL Server 2000 - I had
> exactly the same alert configured with a severity level of 10 and without it
> being logged, and it would quite happily notify me by email when this error
> was raised.
> Regards,
> Jon Ley.
> "John Bell" wrote:
>> Hi Jon
>> "Jon Ley" wrote:
>> > John,
>> >
>> > Thanks for your response. There does not appear to be anything in the error
>> > log.
>> >
>> > Jon.
>> >
>> Under the Alert Properties, there is a history dialog which should show you
>> if the alert has been triggered. If this is not updated when you cause the
>> error then you are not satisfying the criteria described in the remarks
>> section of http://msdn2.microsoft.com/en-us/library/ms189531.aspx. Check that
>> the errors appears in the windows event log.
>> Johnsql

Alert Demo: Sev. 25 Errors - Fatal Error !

Hi, All
I am using SQLserver 2000.
The SQL Server Agent -> Alert says the follower msg:
Demo, Full msbd log
Demo, Full tempdb
Demo, Sev 19Erros (019-Fatal Error in Resource)
Demo, Sev. 20 Errors (020-Fatal Error In Current Process)
....
Demo, Sev. 25 Errors (025 - Fatal Error)
What should I do with these?
Thanks a lot!!!
Michaelproperly ur disk is full, try realse some space to store tempdb's data filesql

agents blocking each other

Contantly there seems to be a blocking issue between the distribution agent,
the log agent, and the distribution clean up agent.
This will eventually cause one of the agents to shut down (the log agent).
What can I do to elevate this situation and why is it happening?
--Kristy
Avoid using EM.
Through Query Analyzer run the distribution clean up agent at a time when
there are few users on the system.
Consider moving to pull subscriptions and possibly a remote distributor.
Hilary Cotter
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
"Kristy" <pleasereplyby@.posting.com> wrote in message
news:%235Ev4idHFHA.3628@.TK2MSFTNGP15.phx.gbl...
> Contantly there seems to be a blocking issue between the distribution
agent,
> the log agent, and the distribution clean up agent.
> This will eventually cause one of the agents to shut down (the log agent).
> What can I do to elevate this situation and why is it happening?
> --Kristy
>
|||Thanks.
Why is it happening and what do the suggestions you provide buy me? Also,
would it be okay to schedule a job to run it? That way the off peak hours
could be utilized best. (I do have to sleep at some point ;-) )
Thanks again,
(and still anxiously awaiting my order to arrive)
Kristy
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u0iLc2gHFHA.2132@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Avoid using EM.
> Through Query Analyzer run the distribution clean up agent at a time when
> there are few users on the system.
> Consider moving to pull subscriptions and possibly a remote distributor.
> --
> Hilary Cotter
> 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
> "Kristy" <pleasereplyby@.posting.com> wrote in message
> news:%235Ev4idHFHA.3628@.TK2MSFTNGP15.phx.gbl...
> agent,
agent).
>
|||In addition Hilary, what does pull subscriptions offer over push ?
"Kristy" <pleasepostreply@.here.com> wrote in message
news:enALdThHFHA.1176@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Thanks.
> Why is it happening and what do the suggestions you provide buy me? Also,
> would it be okay to schedule a job to run it? That way the off peak hours
> could be utilized best. (I do have to sleep at some point ;-) )
> Thanks again,
> (and still anxiously awaiting my order to arrive)
> Kristy
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u0iLc2gHFHA.2132@.TK2MSFTNGP14.phx.gbl...
when
> agent).
>
|||EM, does lots of enumeration and runs far more commands than a simple
command (lets say sp_addsubscription) does. Run profiler to see this.
So if you run a command directly in isqlw you get far less locking.
You can schedule a job to run it, but then you have to log error messages
and make sure that everything runs fine. I would advise you to set your
alarm for 2:00 AM and then log in and do it at that time.
Another thing you can do is stop SQL Server Agent, make your change, and
then restart it.
Pull subscribers run the distribution agent on the subscriber, it connects
with the distribution database on the publisher and results in better
performance on the publisher and less locking.
You might also want to stagger when you agents run - for instance stagger
them to run at a prime number - like every 7 minutes, and don't run them
continuously.
Hilary Cotter
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
"Kristy" <pleasepostreply@.here.com> wrote in message
news:enALdThHFHA.1176@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Thanks.
> Why is it happening and what do the suggestions you provide buy me? Also,
> would it be okay to schedule a job to run it? That way the off peak hours
> could be utilized best. (I do have to sleep at some point ;-) )
> Thanks again,
> (and still anxiously awaiting my order to arrive)
> Kristy
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u0iLc2gHFHA.2132@.TK2MSFTNGP14.phx.gbl...
when
> agent).
>
|||btw - with pull subscriptions you have no central point of administration.
For instance, with push you connect to your publisher in EM and manage your
replication solution. With pull you have to connect to each subscriber and
expand replication monitor to see errors. Make sure you use Replication
Monitor Group to show all your subscribers (use Tools, Replication, Show
Replication Monitor Group and go to the bottom node and right click on
Replication Monitor Group and select add distributor to monitor).
Hilary Cotter
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
"Kristy" <pleasepostreply@.here.com> wrote in message
news:enALdThHFHA.1176@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Thanks.
> Why is it happening and what do the suggestions you provide buy me? Also,
> would it be okay to schedule a job to run it? That way the off peak hours
> could be utilized best. (I do have to sleep at some point ;-) )
> Thanks again,
> (and still anxiously awaiting my order to arrive)
> Kristy
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u0iLc2gHFHA.2132@.TK2MSFTNGP14.phx.gbl...
when
> agent).
>
|||answered above.
Hilary Cotter
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
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eQ1oolhHFHA.2420@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> In addition Hilary, what does pull subscriptions offer over push ?
> "Kristy" <pleasepostreply@.here.com> wrote in message
> news:enALdThHFHA.1176@.TK2MSFTNGP12.phx.gbl...
Also,[vbcol=seagreen]
hours[vbcol=seagreen]
> when
distributor.[vbcol=seagreen]
distribution
>

AgentMail Problem (SQL2K)

Hi,
I use Microsoft outlook as MAPI client. On my own computer, when the outlook
is open, both SQL Mail and Agent Mail can use the file of mail profile to
send email. But on one of client's computer, when outlook is open, it locks
the file of profile and both SQL Mail and Agent Mail fail when try to
connect to profile. When I close outlook, they can access profile. This is
strange behavior that I had never seen elsewhere.
Any help would be greatly appreciated.
Leila
I believe this behavior can depend on your version of Outlook (I prefer Outlook 2000, I've seen the
strange behavior with later versions). It might also be related to whether all users use the same
Windows account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use Microsoft outlook as MAPI client. On my own computer, when the outlook is open, both SQL
> Mail and Agent Mail can use the file of mail profile to send email. But on one of client's
> computer, when outlook is open, it locks the file of profile and both SQL Mail and Agent Mail fail
> when try to connect to profile. When I close outlook, they can access profile. This is strange
> behavior that I had never seen elsewhere.
> Any help would be greatly appreciated.
> Leila
>
|||> It might also be related to whether all users use the same Windows
> account.
If this is the case, then closing the outlook must not solve the problem I
think
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>I believe this behavior can depend on your version of Outlook (I prefer
>Outlook 2000, I've seen the strange behavior with later versions). It might
>also be related to whether all users use the same Windows account.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
>
|||I think that some versions of MAPI (Outlook) doesn't like several Windows accounts using mail at the
same time. Say that Agent and SQL Server uses the same service account. They might not conflict, but
if you are logged in interactively using some other account, you might be in for some problems.
Anyhow, I recommend Outlook 2000. Or actually, I don't recommend SQL Mail at all
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), since it causes so many of these problems...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:OLQuVxOjHHA.2552@.TK2MSFTNGP06.phx.gbl...
> If this is the case, then closing the outlook must not solve the problem I think
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>

AgentMail Problem (SQL2K)

Hi,
I use Microsoft outlook as MAPI client. On my own computer, when the outlook
is open, both SQL Mail and Agent Mail can use the file of mail profile to
send email. But on one of client's computer, when outlook is open, it locks
the file of profile and both SQL Mail and Agent Mail fail when try to
connect to profile. When I close outlook, they can access profile. This is
strange behavior that I had never seen elsewhere.
Any help would be greatly appreciated.
LeilaI believe this behavior can depend on your version of Outlook (I prefer Outl
ook 2000, I've seen the
strange behavior with later versions). It might also be related to whether a
ll users use the same
Windows account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...[v
bcol=seagreen]
> Hi,
> I use Microsoft outlook as MAPI client. On my own computer, when the outlo
ok is open, both SQL
> Mail and Agent Mail can use the file of mail profile to send email. But on
one of client's
> computer, when outlook is open, it locks the file of profile and both SQL
Mail and Agent Mail fail
> when try to connect to profile. When I close outlook, they can access prof
ile. This is strange
> behavior that I had never seen elsewhere.
> Any help would be greatly appreciated.
> Leila
>[/vbcol]|||> It might also be related to whether all users use the same Windows
> account.
If this is the case, then closing the outlook must not solve the problem I
think
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>I believe this behavior can depend on your version of Outlook (I prefer
>Outlook 2000, I've seen the strange behavior with later versions). It might
>also be related to whether all users use the same Windows account.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
>|||I think that some versions of MAPI (Outlook) doesn't like several Windows ac
counts using mail at the
same time. Say that Agent and SQL Server uses the same service account. They
might not conflict, but
if you are logged in interactively using some other account, you might be in
for some problems.
Anyhow, I recommend Outlook 2000. Or actually, I don't recommend SQL Mail at
all
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), since it causes so many
of these problems...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:OLQuVxOjHHA.2552@.TK2MSFTNGP06.phx.gbl...[v
bcol=seagreen]
> If this is the case, then closing the outlook must not solve the problem I
think
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>[/vbcol]

AgentMail Problem (SQL2K)

Hi,
I use Microsoft outlook as MAPI client. On my own computer, when the outlook
is open, both SQL Mail and Agent Mail can use the file of mail profile to
send email. But on one of client's computer, when outlook is open, it locks
the file of profile and both SQL Mail and Agent Mail fail when try to
connect to profile. When I close outlook, they can access profile. This is
strange behavior that I had never seen elsewhere.
Any help would be greatly appreciated.
LeilaI believe this behavior can depend on your version of Outlook (I prefer Outlook 2000, I've seen the
strange behavior with later versions). It might also be related to whether all users use the same
Windows account.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use Microsoft outlook as MAPI client. On my own computer, when the outlook is open, both SQL
> Mail and Agent Mail can use the file of mail profile to send email. But on one of client's
> computer, when outlook is open, it locks the file of profile and both SQL Mail and Agent Mail fail
> when try to connect to profile. When I close outlook, they can access profile. This is strange
> behavior that I had never seen elsewhere.
> Any help would be greatly appreciated.
> Leila
>|||> It might also be related to whether all users use the same Windows
> account.
If this is the case, then closing the outlook must not solve the problem I
think
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>I believe this behavior can depend on your version of Outlook (I prefer
>Outlook 2000, I've seen the strange behavior with later versions). It might
>also be related to whether all users use the same Windows account.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I use Microsoft outlook as MAPI client. On my own computer, when the
>> outlook is open, both SQL Mail and Agent Mail can use the file of mail
>> profile to send email. But on one of client's computer, when outlook is
>> open, it locks the file of profile and both SQL Mail and Agent Mail fail
>> when try to connect to profile. When I close outlook, they can access
>> profile. This is strange behavior that I had never seen elsewhere.
>> Any help would be greatly appreciated.
>> Leila
>|||I think that some versions of MAPI (Outlook) doesn't like several Windows accounts using mail at the
same time. Say that Agent and SQL Server uses the same service account. They might not conflict, but
if you are logged in interactively using some other account, you might be in for some problems.
Anyhow, I recommend Outlook 2000. Or actually, I don't recommend SQL Mail at all
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), since it causes so many of these problems...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:OLQuVxOjHHA.2552@.TK2MSFTNGP06.phx.gbl...
>> It might also be related to whether all users use the same Windows account.
> If this is the case, then closing the outlook must not solve the problem I think
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>>I believe this behavior can depend on your version of Outlook (I prefer Outlook 2000, I've seen
>>the strange behavior with later versions). It might also be related to whether all users use the
>>same Windows account.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I use Microsoft outlook as MAPI client. On my own computer, when the outlook is open, both SQL
>> Mail and Agent Mail can use the file of mail profile to send email. But on one of client's
>> computer, when outlook is open, it locks the file of profile and both SQL Mail and Agent Mail
>> fail when try to connect to profile. When I close outlook, they can access profile. This is
>> strange behavior that I had never seen elsewhere.
>> Any help would be greatly appreciated.
>> Leila
>>
>

Agent will not start

We are moving our SQL Server 2000 databse to a new server. After I
installed it and copied the data over, I found that SQL Server Agent will
not start. I get an Access is denied... message.
The only difference that I know of is that the new server is running Windows
2003 Advanced server and the old serve is not.
Any suggestions?
TIA
Mike
Was this a brand new install? Pls check your sqlagent.out located in the
LOG folder of your SQL Server installation directory for more information
on the error mesg? the sQL Error logs will help as well.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Agent will not start

We are moving our SQL Server 2000 databse to a new server. After I
installed it and copied the data over, I found that SQL Server Agent will
not start. I get an Access is denied... message.
The only difference that I know of is that the new server is running Windows
2003 Advanced server and the old serve is not.
Any suggestions?
TIA
MikeIf you are using a system account to log in the service,
change it to a local or domain account that you know the
password for. If you are using a local or domain account,
set the service to system account (stop and restart the
service) and then re-enter your domain/local account with
the correct password. >--Original Message--
>We are moving our SQL Server 2000 databse to a new
server. After I
>installed it and copied the data over, I found that SQL
Server Agent will
>not start. I get an Access is denied... message.
>The only difference that I know of is that the new server
is running Windows
>2003 Advanced server and the old serve is not.
>Any suggestions?
>TIA
>Mike
>
>.
>|||Was this a brand new install? Pls check your sqlagent.out located in the
LOG folder of your SQL Server installation directory for more information
on the error mesg? the sQL Error logs will help as well.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Agent will not start

We are moving our SQL Server 2000 databse to a new server. After I
installed it and copied the data over, I found that SQL Server Agent will
not start. I get an Access is denied... message.
The only difference that I know of is that the new server is running Windows
2003 Advanced server and the old serve is not.
Any suggestions?
TIA
MikeWas this a brand new install? Pls check your sqlagent.out located in the
LOG folder of your SQL Server installation directory for more information
on the error mesg? the sQL Error logs will help as well.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Agent stops and won't restart

Various sites/servers this is happening.
Start Server AGent
Schedule a DTS to run nightly.
Come back a few days later
SQL SA is stopped
the job never ran
When this first happened I checked the props of SQLSA
and found the "Auto - Restart SQL Server on failure" and "A-R SQL SA..." check boxes.
Checked them.
Come back a few days later. Same results
When I view the jobs in SQL SA- Jobs area those jobs failed for the inimitable
sqlstate 42000 error 8198 "... if the owner
(server\administrator) of job Nightly Update has server access (reason: Could
not obtain information about ... 'server\administrator'.
Yes, the adminitrator. Now I've changed the owner of the jobs to
sa. I'm afraid to presume that sa is powerful enough to stand up to SQL authentication if the admin can't (smirk)
Does anyone have any insights? would the 8198 cause SA to stop? Why would a subordinate job stop SA?
if the sub-job can stop it why doesn't it restart as told to in the properties?
thanks, Bryan
Hi Bryan,
An 8198 error is normally raised when process executed within SQL Server or
from the SQL Server Agent, such as the "xp_logininfo" stored procedure, a
scheduled job, or a replication agent, needs to verify the credentials of a
Windows-authenticated login. The attempt to retrieve those credentials on
the domain failed for an unspecified reason
Please take a look at article
http://support.microsoft.com/default...b;en-us;883551 that talks
about some of the reasons for the 8198 error that you are getting.
Hope that helps !!!
Fargham

Agent started but not started?

I have a SQL 2005 server running on a win2k3 box. For some reason, no
matter what account the SQL Server Agent runs under, error messages
are logged in the security logs. Even if the login account is set to
"local service". BUT if I look at the service under "services", it
says started. It also says started in the SQL 2005 configuration
manager.
Has anyone seen this before?
Thanks
Hello,
Can you create one test job and try executing. If the job runs then SQL
Agent is working fine...also see the SQLAgent.out file in Log folder of SQL
Server
installation folder for any errors
Thanks
Hari
<costello_joe@.hotmail.com> wrote in message
news:1180399298.618353.292290@.q19g2000prn.googlegr oups.com...
> I have a SQL 2005 server running on a win2k3 box. For some reason, no
> matter what account the SQL Server Agent runs under, error messages
> are logged in the security logs. Even if the login account is set to
> "local service". BUT if I look at the service under "services", it
> says started. It also says started in the SQL 2005 configuration
> manager.
> Has anyone seen this before?
> Thanks
>

Agent started but not started?

I have a SQL 2005 server running on a win2k3 box. For some reason, no
matter what account the SQL Server Agent runs under, error messages
are logged in the security logs. Even if the login account is set to
"local service". BUT if I look at the service under "services", it
says started. It also says started in the SQL 2005 configuration
manager.
Has anyone seen this before?
ThanksHello,
Can you create one test job and try executing. If the job runs then SQL
Agent is working fine...also see the SQLAgent.out file in Log folder of SQL
Server
installation folder for any errors
Thanks
Hari
<costello_joe@.hotmail.com> wrote in message
news:1180399298.618353.292290@.q19g2000prn.googlegroups.com...
> I have a SQL 2005 server running on a win2k3 box. For some reason, no
> matter what account the SQL Server Agent runs under, error messages
> are logged in the security logs. Even if the login account is set to
> "local service". BUT if I look at the service under "services", it
> says started. It also says started in the SQL 2005 configuration
> manager.
> Has anyone seen this before?
> Thanks
>

Agent started but not started?

I have a SQL 2005 server running on a win2k3 box. For some reason, no
matter what account the SQL Server Agent runs under, error messages
are logged in the security logs. Even if the login account is set to
"local service". BUT if I look at the service under "services", it
says started. It also says started in the SQL 2005 configuration
manager.
Has anyone seen this before?
ThanksHello,
Can you create one test job and try executing. If the job runs then SQL
Agent is working fine...also see the SQLAgent.out file in Log folder of SQL
Server
installation folder for any errors
Thanks
Hari
<costello_joe@.hotmail.com> wrote in message
news:1180399298.618353.292290@.q19g2000prn.googlegroups.com...
> I have a SQL 2005 server running on a win2k3 box. For some reason, no
> matter what account the SQL Server Agent runs under, error messages
> are logged in the security logs. Even if the login account is set to
> "local service". BUT if I look at the service under "services", it
> says started. It also says started in the SQL 2005 configuration
> manager.
> Has anyone seen this before?
> Thanks
>

Agent services

There is no SQL Server Agent with SQL Server Express. Not
sure what you were looking to do but you can often use the
Windows Scheduler and sqlcmd scripts to accomplish a lot of
things you would have done in Agent.
-Sue
On Wed, 21 Mar 2007 20:24:42 +0100, "Ana" <nospam@.yahoo.com>
wrote:

>Hi,
>How to activate the Agent on SQLExpress05?
>TIA
>Ana
>
>----
>Estoy utilizando la versin gratuita de SPAMfighter para usuarios privados.
>Ha eliminado 3003 correos spam hasta la fecha.
>Los abonados no tienen este mensaje en sus correos.
>Pruebe SPAMfighter gratis ya!
>
To add on to Sue, take a look into below links to backup the SQL Express
databases:-
http://www.sqldbatips.com/showarticle.asp?ID=27
http://www.sqldbatips.com/showarticle.asp?ID=29
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:dmj303ls7b691rdqqhm205glau580q6ego@.4ax.com...
> There is no SQL Server Agent with SQL Server Express. Not
> sure what you were looking to do but you can often use the
> Windows Scheduler and sqlcmd scripts to accomplish a lot of
> things you would have done in Agent.
> -Sue
> On Wed, 21 Mar 2007 20:24:42 +0100, "Ana" <nospam@.yahoo.com>
> wrote:
>

Agent Service Fails to Start

For some time now, I've been unable to start SQL Server
Agent service. I can run agent in cmd window via:
sqlagent.exe -c -v. The error on failed startup is
something like, sqlagent failed to start in a timely
manner.Have you tried starting the agent from Service Manager? If so, what error
message do you get? What user account does the Agent run with? Does the
account belong to a Win2K domain or the local machine?
The answers to these questions will help to diagnose the problem.
"Clark" <anonymous@.discussions.microsoft.com> wrote in message
news:4a2e01c3ab7d$eebde570$a601280a@.phx.gbl...
> For some time now, I've been unable to start SQL Server
> Agent service. I can run agent in cmd window via:
> sqlagent.exe -c -v. The error on failed startup is
> something like, sqlagent failed to start in a timely
> manner.|||Oh yes, I've tried that.
1. With Service Manager, it fails to start with something
like, sqlagent failed to start in a timely manner.
2. Agent uses the sama account as SQL Server service.
I plan to dink with this on Monday morning.
Question: Can the time to load a service be extended,
for example, to load a service on a very busy server?
>--Original Message--
>Have you tried starting the agent from Service Manager?
If so, what error
>message do you get? What user account does the Agent run
with? Does the
>account belong to a Win2K domain or the local machine?
>The answers to these questions will help to diagnose the
problem.
>
>"Clark" <anonymous@.discussions.microsoft.com> wrote in
message
>news:4a2e01c3ab7d$eebde570$a601280a@.phx.gbl...
>> For some time now, I've been unable to start SQL Server
>> Agent service. I can run agent in cmd window via:
>> sqlagent.exe -c -v. The error on failed startup is
>> something like, sqlagent failed to start in a timely
>> manner.
>
>.
>|||I am having a similar problem too. I am trying to start the service from
Enterprise Manager and get the following error:
A error 5 - (Access is denied) occured while performing the service opeation
on the SQL ServerAgent service
I tried changeing the account info to the SA login and password but to no
avail. Is it possibel that the service is needs the machine domain Admin
account info?
John.
"Clark" <anonymous@.discussions.microsoft.com> wrote in message
news:505301c3ac4e$be0c0070$a601280a@.phx.gbl...
> Oh yes, I've tried that.
> 1. With Service Manager, it fails to start with something
> like, sqlagent failed to start in a timely manner.
> 2. Agent uses the sama account as SQL Server service.
> I plan to dink with this on Monday morning.
> Question: Can the time to load a service be extended,
> for example, to load a service on a very busy server?
>
> >--Original Message--
> >Have you tried starting the agent from Service Manager?
> If so, what error
> >message do you get? What user account does the Agent run
> with? Does the
> >account belong to a Win2K domain or the local machine?
> >
> >The answers to these questions will help to diagnose the
> problem.
> >
> >
> >"Clark" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:4a2e01c3ab7d$eebde570$a601280a@.phx.gbl...
> >> For some time now, I've been unable to start SQL Server
> >> Agent service. I can run agent in cmd window via:
> >> sqlagent.exe -c -v. The error on failed startup is
> >> something like, sqlagent failed to start in a timely
> >> manner.
> >
> >
> >.
> >|||Hi John,
Sa login is for SQL server authentication, which is different from the account used for SQL server agent service. To run sql server agent, one must typically have a domain user account (as it is used for sql mail, replication, backup etc). Also this domain name should have administrative privs on the machine where sql server instance is running.
Sometimes I guess rebuilding registry can solve the problem. Use "regrebld" in the cmd line prompt. I haven't used this utility myself, so inquire with others before using it
Thank
GYK|||Thanks for you help.
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:CFD08193-68CB-48CA-A931-04BBA0EC21A2@.microsoft.com...
> Hi John,
> Sa login is for SQL server authentication, which is different from the
account used for SQL server agent service. To run sql server agent, one must
typically have a domain user account (as it is used for sql mail,
replication, backup etc). Also this domain name should have administrative
privs on the machine where sql server instance is running.
> Sometimes I guess rebuilding registry can solve the problem. Use
"regrebld" in the cmd line prompt. I haven't used this utility myself, so
inquire with others before using it.
> Thanks
> GYK

Agent Scheduling Confusion....

I'm a little confused.
I've been working on setting up one snapshot publication for one DB, and one
"one-way" transactional publication for another DB (both on the same
server).
My three "client" subscribers are running MSDE 2000 SP3, and they are
subscribing to these to Publishers.
As I have been in the process of setting these up, I'm having difficulty
understanding how all the "scheduling" works.
I mean there's a schedule for the "snapshot" agent. a schedule for the
"transactional" agent, a schedule for the "distribution" agent, a schedule
for the "subscriber" agent, ... and so on.
For my scenario, I need to know how to configure all the schedulers
(publisher and subscribers) so that when the "client" subscriber is
connected to the network, it automatically checks to see if there is an
updated snapshot, and see if there are any "transactional" transactions
published at the publisher. I want the publisher to publish the "snapshot"
every day at 3:00 AM, and I want the "transactional" publication to always
be "up-to-date".
Any ideas on where to get the most useful information about all the
"scheduling", or should I buy a book on replication
I've become pretty much adept at the actual setting up of all the security,
folders, etc. I'm just real unsure about the scheduling of the different
agents...
Thanks
-- Will G.
When you want the subscriber to determine when to connect to the publisher
and download updates you should be using a pull subscription.
Either that or use a push subscription and schedule your distribution agent
to run every 1 minute and have it fail continually until the subscriber
connects. The first option is the better way to go.
You can schedule your pull agent to run continuously. You might want to
configure your subscription to be managed by Windows Synchronization Manager
for a greater range of options on when to pull your subscription, for
instance it can pull your subscription on logon, when the network connection
is live, etc.
If you schedule your snapshot to run every morning at 3:00 it will only be
generated the first time, and subsequent times when a subscription needs
reinitialization, ie you made a schema change or the subscription expired.
You are still probably confused. Post back with any remaining or new
questions you might have, and someone should pick them up and answer them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Will Gillen" <gille001@.nsuok.edu> wrote in message
news:ODw6zwevEHA.3080@.TK2MSFTNGP12.phx.gbl...
> I'm a little confused.
> I've been working on setting up one snapshot publication for one DB, and
one
> "one-way" transactional publication for another DB (both on the same
> server).
> My three "client" subscribers are running MSDE 2000 SP3, and they are
> subscribing to these to Publishers.
> As I have been in the process of setting these up, I'm having difficulty
> understanding how all the "scheduling" works.
> I mean there's a schedule for the "snapshot" agent. a schedule for the
> "transactional" agent, a schedule for the "distribution" agent, a schedule
> for the "subscriber" agent, ... and so on.
> For my scenario, I need to know how to configure all the schedulers
> (publisher and subscribers) so that when the "client" subscriber is
> connected to the network, it automatically checks to see if there is an
> updated snapshot, and see if there are any "transactional" transactions
> published at the publisher. I want the publisher to publish the
"snapshot"
> every day at 3:00 AM, and I want the "transactional" publication to always
> be "up-to-date".
> Any ideas on where to get the most useful information about all the
> "scheduling", or should I buy a book on replication
> I've become pretty much adept at the actual setting up of all the
security,
> folders, etc. I'm just real unsure about the scheduling of the different
> agents...
> Thanks
> -- Will G.
>
>