Oh, OK.

I am planning to drop an amount figure into one of three columns based on the due date in that record, so the 'ageing' is reported for amounts due...

We found the problem. By creating a folder to save the backup files in that had modify security on it the jobs ran through.

Thanks

Robert

I obtained the attached screen prints, but am not compleetly sure they are what you are asking for....

Regards

Robert

I am not sure I can get that, and have to wait anyway until I get logged on again to the machine.

What will the information look like?

USE [msdb]

GO

/****** Object: Job [Full Morning Backup Plan 00_30.Subplan_1] Script Date: 05/10/2012 10:39:55 ******/

BEGIN TRANSACTION

DECLARE @ReturnCode INT

SELECT @ReturnCode = 0

/****** Object: JobCategory [Database Maintenance] ...

Can do, but it will have to be tomorrow now, I don't have a login and have to wait for the sysadmin guy to connect me.

The jobs are a full...

I have noted the following:

Shared Memory

Named Pipes

TCP/IP

were all Enabled - see screenshot attached.

not sure what to check next.

Thanks

Robert

Thanks Mike,

Please excuse my ignorance, I am not very experienced with SQL Server, but have been tasked with setting up some Maintenance Plans.

Also, I have to wait for my sysadmin...

I was able to check that the user could connect to SQL, but now the job still errors:

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted

05/09/2012 11:25:07,Full...

Thanks for that, how do I check the sql connect permission?

What should I look at in terms of permissions?

Anyone??

Thanks Guys,

Your comments are much appreciated. I can see where the inconsistencies have crept into our current application, and hope to lay down a standard with it's replacement.

What surprised me...