Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Get the executing Job that targets the local server Expand / Collapse
Author
Message
Posted Thursday, July 21, 2011 9:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Saturday, December 10, 2011 2:10 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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 »

Add to briefcase

Permissions Expand / Collapse