DTS Error - No Server access

[Jusenkyo]

Hello All

I run several DTS packages in the middle of the night, and 90% of them run correctly. the other 10% display this error message;

"The job failed. The owner() of job DBName does not have server access. NOTE: Failed to notify 'ICT' via email."

These packages are based on tables that have the same access and dbo as all other tables.

Does anyone have any idea what else cold be the problem???

Cheers

 

[tb]

Were they save with SQL authentication or windows authentication ?

It might be that the ones who fail maight be saved with a username that doesn't have access to the db



"All I ask is the chance to prove that money can't make me happy." - Spike Milligan