Hi,
I am able to run all my DTS jobs manually, but when I try to run the shceduled jobs for those DTS, they all fail. It seems to be a security issue, but no matter who the owner is of job or dts, the jobs fail.
This has started today as a complete reinstall of OS and SQL Server was needed after a hacker got in to the server and caused havoc. We restored all databases to a point before the hack - everything should be exactly the same as it was before.
Any ideas why I can run the DTS manually but the jobs fail?
Thanks!