[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Running SQL jobs under different accounts

Posted on 2007-12-06
3
Medium Priority
?
1,000 Views
Last Modified: 2008-09-08
Hi

We have 2 identical jobs on 2 identical databases running on different servers, both the same build and service pack.  One is running properly when scheduled and the other isn't - the job is backing up databases to a linked device

How do I find out what account the job is running under, is it the agent that dictates this or do the account used to set up the job or the job owner come into play?

thanks

0
Comment
Question by:ESiTLimited
1 Comment
 
LVL 7

Accepted Solution

by:
Alpha Au earned 200 total points
ID: 20425237
You can check the account running SQL JOB Agent
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question