Weird situation on my SQL 2000 server:
Trusted domain users can create scheduled jobs under SQL
Server Agent. When the users execute jobs, the jobs get
failed.
The owner of these jobs have to be chenged to a local
user of SQL server. Then trusted domain user can execute
the jobs.
I do not know how to help trusted users run jobs without
changing ownership.

Thanks for any suggestions.

Do you get an error when the trusted user owned job runs?

Rand
This posting is provided "as is" with no warranties and confers no rights.