Get the executing Job that targets the local server

• richarddelcarmen

  SSChasing Mays

  Points: 625

  More actions

  July 21, 2011 at 9:53 pm

  #145798

  Hi guys,

  There is a job in a remote server that targets the a database in the local server. The job truncates and imports data to the tables in the local database.

  I want to get the information about the executing job like the job name, host name, login used to connect to the server, etc.

  Is this possible?

• salum

  SSCommitted

  Points: 1598

  More actions

  December 10, 2011 at 2:10 am

  #1419693

  Is this SQL Agent job created on remote server? if yes and you have access on that instance then you can simply see Agent jop properties.

  java[/url]