Hi Lynn:

Thanks for the response.

Putting aside the fact that Paging and Net Send are scheduled to be depreciated and shouldn’t be used for any new development, I still have an...

Greetings Jeffery:

The job in question was created through a maintenance plan generated through the SSIS. The “generated” T-SQL for the backup process from SSIS is:

EXECUTE master.dbo.xp_create_subdir N'F:\MSSQL\MSSQL.1\MSSQL\Backup\master'

GO

EXECUTE master.dbo.xp_create_subdir N'F:\MSSQL\MSSQL.1\MSSQL\Backup\model'

GO

EXECUTE...

Greetings Jeffrey:

Checked the connection string. It appears correct. Also checked the services. There are not any other instances of SQL Server on this box.

Thanks.

USKiwi

Greetings Homebrew01:

This is what the log states for the job:

NEW COMPONENT OUTPUT

Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4285

Report was generated on "CHIVMC01".

Maintenance Plan: Full backup of system databases

Duration: 00:00:00

Status: Succeeded.

Details:

Interestingly,...

There is only one step which launches an SSIS maintenance plan. There not any steps beyond this. The job reports an error on failure and success upon success. I can...

I don't know much about lifts and getting on the ground floor and getting off on the first. However, I have herded sheep - be it in another life and another time. None I...

This might gauge your thought processes but I've always perferred something more specific to the job being performed. When I was interviewing for DBA's for a group I was...

Interesting demonstration of the ROW_NUMBER() function. Please say it ain’t so, Joe! - that you are not using cursors to remove duplicate rows.