I have a DTS job which fails when scheduled. I have other jobs running that are scheduled that complete with no problemo.
I can run the suspect DTS job manually only. This subject was discussed earlier in the month but the solution was not
clear to me. I realize this is permissions related but the SQL Agent appear correct and are acceptable for other jobs I have.

Any advice please.

Thanks,
Justin


MS Sql Server LazyDBA home page