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

Change Tracking VS Update Index

When creating a new Table Schedule, there is an option for a Job Type of
"Update Index". I though this was Change Tracking, but it doesn't seem to
be. I still had to manually select Change Tracking from the full text menu.
What is Update Index?
Thanks
It is, but change tracking has two modes:
1) update index is a scheduled update, ie you can update the index on demand
or as a scheduled job
2) update index in background - ie have it happen continuously
"Don Schilling" <fake@.ReplyToGroup.com> wrote in message
news:OMa3r$2PEHA.648@.TK2MSFTNGP10.phx.gbl...
> When creating a new Table Schedule, there is an option for a Job Type of
> "Update Index". I though this was Change Tracking, but it doesn't seem to
> be. I still had to manually select Change Tracking from the full text
menu.
> What is Update Index?
> Thanks

Change name of exported csv file

Hi guys,
I have created a report with Reporting Services 2005 that gets executed according to a schedule I have created, every working date and the output gets exported to a csv file. My problem is that I want the exported file to have the running date append to it, e.g. report "Myrep" gets exported as "Myrep.csv" but I want to have it as "Myrep070607.csv"

Thanks in advanceHi
pzou
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.

It will help Experts in the forum in solving/underestanding your problem in a better way.|||Is it in ms.net

please clarify.