If you go to the job in the management folder and right click on the job
then go to properties, who is the job owner? Does the security context
of that owner allow them to run the job?

-----Original Message-----
From: Justin Gilli [mailto:[Email Address Removed]
Sent: Monday, October 13, 2003 3:44 PM
To: LazyDBA.com Discussion
Subject: DTS job failing when scheduled

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