Multi Server Job Activity Monitor Possible or Not?

Hi,
I am using SQL Server Management Studio to manage both 2000 and 2005
servers. I would like to see a Job Activity Monitor window that covers all
servers. Is it possible to this?
We check all the scheduled jobs have completed successfully on each server
each day any suggestions best practice for doing this will be most welcome.
Many Thanks,
Paul.
You should look at SQL Sentry Event Manager.
http://www.sqlsentry.net/
Aaron Bertrand
SQL Server MVP
"Paul" <PaulC@.newsgroups.nospam> wrote in message
news:95366CF2-A6E4-4E6A-B8B7-8432CF4A8E9E@.microsoft.com...
> Hi,
> I am using SQL Server Management Studio to manage both 2000 and 2005
> servers. I would like to see a Job Activity Monitor window that covers all
> servers. Is it possible to this?
> We check all the scheduled jobs have completed successfully on each server
> each day any suggestions best practice for doing this will be most
> welcome.
> Many Thanks,
> Paul.
>
|||I second Aaron's suggestion. If you have multiple servers and want to
monitor, schedule and get overall control of the jobs across them there is
no better tool on the market.
Andrew J. Kelly SQL MVP
"Paul" <PaulC@.newsgroups.nospam> wrote in message
news:95366CF2-A6E4-4E6A-B8B7-8432CF4A8E9E@.microsoft.com...
> Hi,
> I am using SQL Server Management Studio to manage both 2000 and 2005
> servers. I would like to see a Job Activity Monitor window that covers all
> servers. Is it possible to this?
> We check all the scheduled jobs have completed successfully on each server
> each day any suggestions best practice for doing this will be most
> welcome.
> Many Thanks,
> Paul.
>

Multi publisher single subscrier Replication

I had a multi publisher single subscriber replication in my job and now i want remove it. i disabled the subscriber. Now if i disable the publisher and distributor then it gives me a error cannot drop the distribution DB because it is currently in use. this DB can never be dropped since there is at least one publisher at one time that accesses this DB everytime. How should I disable this publication.

Disable each Publisher, removing any publications caused by that Publisher. Leave the Distribution database until you are removing the final Publisher and then it 'should' be removable.

sql

MsSql Server 2000 Backup to tape

i have 3 schedule job for backing up different databases (4 database) to a
tape drive.
first job is to do database backup.
2nd job is to backup different database.
3rd job is to backup Transaction log database.
each job consist of 4 step, which each step is for each database
when schedule sometimes i get the message The file on device '\\.\Tape0' is
not a valid Microsoft Tape Format backup st.[Sqlstate 42000])error 3242)
Backup database is terminating abnormally. [ Sqlstate 42000](error 3013)
. the
step fail
but sometime it can go thru the job.
Please Help. Thanks
EHTanHi
Have you thought of changing to backing up to disc and then to tape?
John
"EngHim" wrote:

> i have 3 schedule job for backing up different databases (4 database) to a
> tape drive.
> first job is to do database backup.
> 2nd job is to backup different database.
> 3rd job is to backup Transaction log database.
> each job consist of 4 step, which each step is for each database
> when schedule sometimes i get the message The file on device '\\.\Tape0' i
s
> not a valid Microsoft Tape Format backup st.[Sqlstate 42000])error 324
2)
> Backup database is terminating abnormally. [ Sqlstate 42000](error 301
3). the
> step fail
> but sometime it can go thru the job.
> Please Help. Thanks
> --
> EHTan

MsSql Server 2000 Backup to tape

i have 3 schedule job for backing up different databases (4 database) to a
tape drive.
first job is to do database backup.
2nd job is to backup different database.
3rd job is to backup Transaction log database.
each job consist of 4 step, which each step is for each database
when schedule sometimes i get the message The file on device '\\.\Tape0' is
not a valid Microsoft Tape Format backup st.[Sqlstate 42000])error 3242)
Backup database is terminating abnormally. [ Sqlstate 42000](error 3013). the
step fail
but sometime it can go thru the job.
Please Help. Thanks
--
EHTanHi
Have you thought of changing to backing up to disc and then to tape?
John
"EngHim" wrote:
> i have 3 schedule job for backing up different databases (4 database) to a
> tape drive.
> first job is to do database backup.
> 2nd job is to backup different database.
> 3rd job is to backup Transaction log database.
> each job consist of 4 step, which each step is for each database
> when schedule sometimes i get the message The file on device '\\.\Tape0' is
> not a valid Microsoft Tape Format backup st.[Sqlstate 42000])error 3242)
> Backup database is terminating abnormally. [ Sqlstate 42000](error 3013). the
> step fail
> but sometime it can go thru the job.
> Please Help. Thanks
> --
> EHTan