Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

Job Dependencies in SQL Server Agent:

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
enrique_aeo
Asked:
enrique_aeo
1 Solution
 
Pawan KumarDatabase ExpertCommented:
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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now