How to change replication agent's default profile properties....

Hi,
my problem is: we have poor line between servers. To avoid this issue i
created new profile for distribution agent. This profile has been
created with bigger QieryTimeout and LogonTimeout values. After that i
assigned this profile to distribution agent and SQL Server agent was
restarted after this. According to new settings replication works fine.
But: i've found, that may be my boss, may be somebody else rolled back
all my changes and restored "system default" profile for distribution
agent. After this replicaion fault every time. So every morning i
assigned my profile, every night "default" profile has been restored.
My question is: is it possible to change "default" profile settings? I
saw MSdistribution_agent table, found job description, where profile_id
= 4. Where i should looking for details of profile settings?
Thanks a lot in advance.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
We do not recommend updating the default profile, I'm not quite sure if i
understand what you mean by "rolled back" changes.
What you did is the recommended way of changing the profile values.
thanks
gopal
|||Many thanks for all.
"roll back" means, that i assigned my profile to distribution agent, but
next morning i saw "default" profile assigned to the same agent.
This issue now sorted out because i found MSagent_profiles,
MSagent_properties tables in msdb.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

How to call job step X from job step Y:

I have a SQL Server Agent job with multiple steps. I want
to be able to goto a specific job steps by choice from a
step within the job. How do I make a acll to another step
from a job step.
For example, based on data returned in step 5, I could go
to step 1, 2, 3 or 4. 'OnSuccess', OnFailure' flow is not
good enough in the given scenario. I don't want to use
sp_start_job to start the job at a specific step because
the job is already running and I just want to set the
control-of-flow to a different step.
Thanks
Abdul Gill
DBA/Royal Caribbean Cruise LimitedHi Abdul
Job Step control does limit your options for controlling process flow, so
how about using a DTS package? DTS gives you easy control over process flow
& can be scheduled into a SQL Agent Job as well. The tools for implementing
complex processes are far more advanced in DTS, there's even a GUI to
support visualisation of the process logic..
Regards,
Greg Linwood
SQL Server MVP
"Abdul M. Gill" <agill@.rccl.com> wrote in message
news:1474e01c41381$3b8f6a20$a101280a@.phx
.gbl...
> I have a SQL Server Agent job with multiple steps. I want
> to be able to goto a specific job steps by choice from a
> step within the job. How do I make a acll to another step
> from a job step.
> For example, based on data returned in step 5, I could go
> to step 1, 2, 3 or 4. 'OnSuccess', OnFailure' flow is not
> good enough in the given scenario. I don't want to use
> sp_start_job to start the job at a specific step because
> the job is already running and I just want to set the
> control-of-flow to a different step.
> Thanks
> Abdul Gill
> DBA/Royal Caribbean Cruise Limited