Monday, March 19, 2012

Changed Snapshot Agent Schedule, but Agent still running on old on

I recently changed my snapshot agent schedule to run 1x each night. In the
Job History (SQL Server Agent), it shows to run as scheduled. However, when
I look at the Agent History, it is recording session activity every hour.
What is going on here?
Thanks,
Buddy
Hi,
Try to stop and start SQL Agent and if doesn't work, try to create a new
profile in the Snapshot agent properties/agent profiles and click to use this
new profile avoiding the default.
Regards
"Budman" wrote:

> I recently changed my snapshot agent schedule to run 1x each night. In the
> Job History (SQL Server Agent), it shows to run as scheduled. However, when
> I look at the Agent History, it is recording session activity every hour.
> What is going on here?
> Thanks,
> Buddy

No comments:

Post a Comment