This is what I use to list failed jobs

SELECT DISTINCT

CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11))AS 'Failure Date',

SUBSTRING(T2.name,1,40)AS 'Job Name',

T1.step_id AS 'Step_id',

T1.step_nameAS 'Step Name',

LEFT(T1.[message],500)AS 'Error Message'

FROM msdb..sysjobhistory T1

JOINmsdb..sysjobsT2

ON T1.job_id = T2.job_id

WHERET1.run_status...

Great stuff. All sorted now 🙂

Thanks 😉

The 'thread below' would help 😉

That is what my senior developers and architects are recommending whilst I'm sat here pulling my hair out 😉

To me business logic should be in all layers,not one.

Many thanks to all those who have posted.

Thanks Noel,

New problem. Now when I try to browse to the new directory via enterprize manager its only showing me the one existing drive. I'm confused as when I look...

Thanks for that. Unfortunately I do have to have the sequencing right so looks like Shaping services for me then....

That did the trick thx