Thanks George. I'll take a look at the link and let you know how I get on.

Hi,

I think I understand what you are trying to do, but I think you might be a bit of target.

I can't see where you are dynamically creating the connection string...

Tim,

I'm yet another person to benifit from your fix. 😀

Thanks - work like a charm

Hi thanks.

I gone down the route of using the stored procedure and it would seem to now work as I expected it to.

As I need to disable a few jobs,...

Well scripting out and re-creating seems a little over-kill to me.

However, it has lead me onto somthing else. looking at MSDN, SQL agent re-caches a job following a modification,...

Thanks adam. We pretty much found the permissions were the issue.

My colleague and I have just found that we need to specificy the SQL Service Account as part of...

Hi

I'm trying to get this working on our servers, so that we can stop services as part of a scheduled job, but it appears that it won't run unless we...

Has anyone mirrored the reporting services database so that is can be failed over using Database mirroring

We are implemented a mirroring solution that fails over automatically week on week as a sort of automated DR test (so we know, that should we fail over when things...

The T-SQL I'm running as part of a scheduled job to enable / disable the job is as follows:

USE msdb

UPDATE sysjobs

SETEnabled = 0

WHERE[Name] LIKE 'DB Backup%';

This appears to work...

Yeah the jobs are running based on their schedule and that I am aware of there is now web schedules.

I do have SSRS configured, but this are only SQL Server...

Hi

I would restart your mirroring.

The easiest way to check that the mirror is being updated in to use the sql database mirroring monitor. (this will tell you if the...

Hi,

This is a great idea and I've just done something similar, but more focused on producing server documentation of jobs, backup devices etc etc.

What I'd like to suggest is a...

hi,

did you get an answer to your question?

Do you know where I could find any details on how to configure SSRS mirroring and whats involved (more so from the SSRS...

Cheers.

I managed to find some useful tips on MS SQL Tips (http://www.mssqltips.com/tip.asp?tip=1329).

To do it, I had to change my report slightly to have the 'summary' job details at a group...