I am running SQL Server 2000 on Windows 2003. I have several jobs that run,
and I have noticed two issues. First of all, some of my scheduled jobs
appear to be running twice as I receive two email notifications for each job.
However I also notice in my logs that jobs seem to execute only once. I've
run a virus scan and updated with critical updates.

Secondly, I updated a job that backs up databases. I changed the names of
the backups. When the job runs the database is backed up twice - once with
the old name (which I did not save) and once with the new name. I have
scripted out the job, and I see no mention of the old names in the script.

Has anyone run into similar issues?

Best,
deka

You must have two backup jobs there somewhere. The sysjobhistory system
table in msdb will show you all jobs that run and when if there is any
confusion when looking on the tools.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"deka" <deka (AT) discussions (DOT) microsoft.com> wrote