Solved

Job Dependencies in SQL Server Agent:

Posted on 2016-11-24
1
30 Views
Last Modified: 2016-11-25
hi experts

i am reading about Job Dependencies in SQL Server Agent:
what's the mean?
Question: Which SQL Server resources would SQL Server Agent jobs potentially depend upon?
Question: Which resources outside SQL Server might SQL Server Agent jobs depend upon?
Question: Which permissions are needed for accessing the external resources?
0
Comment
Question by:enrique_aeo
1 Comment
 
LVL 23

Accepted Solution

by:
Pawan Kumar earned 500 total points
ID: 41901116
What SQL Server resources would SQL Server Agent Jobs potentially depend upon?

It depends but it should include databases, tables, views, stored procedures, functions.

What resources outside of SQL Server might SQL Server Agent jobs depend upon?

It depends but might need to include  the local paths and shares, remote SQL Server systems, Analysis Services, SSIS Packages, network services, local processes.

Which permissions are needed for accessing the external resources?

Windows identity for the external resource.

Ref more for -
files.hii-tech.com/SQLServer/Slides-6231B/6231B_14.pptx
http://go.microsoft.com/fwlink/?LinkID=213501
https://msdn.microsoft.com/en-in/library/ms143504.aspx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How can I get blanks instead of zero's to show up in my results? 2 29
Sql query 34 35
Pivot not using aggregate yield error 3 41
Sql Query Datatype 2 14
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now