SQL Server Performance

Job executer information

Discussion in 'SQL Server 2005 Integration Services' started by ashish.johri, Oct 11, 2007.

  1. ashish.johri New Member

    Can I find out the user who has executed the job?
    The result of query Q1) gives this information in the message column of the output.
    Q1) select * FROM Msdb..sysjobhistory
    Do we have any other table or SP from this information can be captured directly?
  2. bradmcgehee New Member

    With SQL Server 2005 Profiler, there are a lot of audit events you can use to capture quite detailed information on who is doing what on your server. This might work for you.
  3. Greg Larsen New Member

    Are you asking for the user that started the job, or the user context in which the job was ran under?
  4. ashish.johri New Member

    Sir I am asking the table which has the information of "user context in which the job was ran under"
  5. satya Moderator

    Any reason to put this in SSIS forums?
    As referre by Brad using PROFILER you could achieve it, more over you could referred to the sys.catalogs for jobs in thsi case to get more information. Take a tour to books online for such catalog views.q

Share This Page