In SQL2000 I try and use NT Authentication using the sysadmin role. I choose
a long password for sa and then lock it up and never use it. I usually run
SQLAgent jobs on production machines as my own NT account which is a member
of the sysadmin role.

As long as the user is in the sysadmin role it doesn't matter. If someone
else wants to run a job you need to set up a proxy account, etc, all
explained in BOL.

Mark.
www.allisonmitchell.com

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] 28 February 2002 13:35
To: [Email Address Removed] running a scheduled job vs. as SA


What are the differences between running a scheduled job (I think that's
the SQL Agent account)
and as sa?

-Kevin

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.

For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford Chance office.
MS Sql Server LazyDBA home page