Further to my continuing troubles in this question: http://ask.sqlteam.com/questions/856/how-to-execute-jobs-from-the-sql-server-enterprise-manager how do I check what the default database is for the SA user?
I am still having problems getting these jobs to execute. :(
Thanks in advance.
Do the jobs only perform actions within the sql server instance that hosts the job? In other words if the job is trying connect to a linked server or the (local or remote) file system or launch a non-sql process then you may need to change the owner to a domain account that has the necessary privs.
EDIT: btw - the first result set of the following command will show the default db:
exec sp_helplogins sa
SELECT name,
dbname
FROM sys.syslogins
WHERE name = 'sa'
