Get the executing Job that targets the local server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » Get the executing Job that targets the local...

Get the executing Job that targets the local server

Rate Topic

Display Mode

Topic Options

Author

Message

richarddelcarmen

Posted Thursday, July 21, 2011 9:53 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 31, 2012 8:21 AM
Points: 21, Visits: 165

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?

Post #1146420

salum

Posted Saturday, December 10, 2011 2:10 AM

Valued Member

Group: General Forum Members
Last Login: Sunday, September 23, 2012 8:09 AM
Points: 70, Visits: 157

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

Post #1219783

« Prev Topic | Next Topic »

Permissions