Check your service accounts are not locked out if they are network accounts. If this does not work then set your service accounts to local system and try again.

Try this one.....

SET NOCOUNT ON

DECLARE @LogicalFileName sysname,

@MaxMinutes INT,

...

the dates are not stored as dates more like yyyymmdd. My trouble is i do not seem to be able to refer to the dest table in the select...