Check the command line for the SQL Agent Job. The command line should have something like:

ESCAPE_NONE(SRVR) for the SRV parameter. Another shot in the dark...

As Lynn stated - nothing wrong with it. For me, it would depend on how often I am running the tlog backups and when the full backup is scheduled.

If...

Well - I am not sure where that is being stored. I am going to keep looking and will let you know if I find anything.

And, while you are at it - check the value of 'orginating_server_id' in the sysjobs table.

SELECT * FROM msdb.dbo.sysjobs;

Okay - try the following:

SELECT * FROM msdb.dbo.sysjobservers;

Edit: fixed type from sysservers to sysjobservers.

What do you get from SELECT @@servername;

Well, I am not sure about that - let me take a look around and see if I can find something.

Generally, I have found the best method is to just...

How exactly did you get those maintenance plans onto the new 2008 system? Did you restore the msdb database from the 2005 system to the 2008 system?

If so, then...

Using read uncommitted is the same as using (NOLOCK) - and, you are finding out exactly why this is not something that you do to work around issues.

There are several...

For a simpler method, you can grant execute privileges on a schema. For example:

GRANT EXECUTE ON SCHEMA::dbo TO {role or user};

Now, if someone creates a new procedure - you...

Using Powershell installed on any system that has network access:

PS> Get-WMIObject Win32_Service -computer {computer} | ? {$_.Name -like 'MSSQL*'} | Select Name, State

You can then extend this to send email...

In 2005 - you have to add the Maintenance Cleanup Task to the maintenance plan and configure it. Sounds to me like that does not exist in the plan...

Glad I could help and you were able to get something to work.

ehlinger (3/1/2009)

---

Jeffrey,

You aren't missing anything. I just didn't explain the whole picture well enough. The reason it won't work to do filtering on the adjustments table is because...

I really don't understand why you even need the #PointPartners table. Since all you are doing is filtering that table where the AdjustmentName is like 'PP_%' - and, you...