locked
Log files RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Everybody,

    Where can i check Logfiles in MS SQL SERVER 2005 i have some jobs these jobs are backups jobs and Refresh jobs where cani check these jobs Log files


    Can anybody reply so early..with step by step.

    Tx
    subu
    Tuesday, January 19, 2010 8:52 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Login to your SQL server and go to SQL server agent tab.

    Open the agent node and you will see all the jobs listed under the jobs tab.

    Right click the specific job and click on view history to see the log history for this job.

     

    Also you can use query the msdb databases tables

     

    select * from sysjobhistory

    Thanks, Leks
    Tuesday, January 19, 2010 10:11 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote
    I guess he is looking for the job log files. Go to the job step properties (Job - Properties - steps - edit - Advanced) and Advanced tab to see the job output log file path.
    Ranjith | My Blog
    Wednesday, January 20, 2010 12:33 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Login to your SQL server and go to SQL server agent tab.

    Open the agent node and you will see all the jobs listed under the jobs tab.

    Right click the specific job and click on view history to see the log history for this job.

     

    Also you can use query the msdb databases tables

     

    select * from sysjobhistory

    Thanks, Leks
    Tuesday, January 19, 2010 10:11 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote
    I guess he is looking for the job log files. Go to the job step properties (Job - Properties - steps - edit - Advanced) and Advanced tab to see the job output log file path.
    Ranjith | My Blog
    Wednesday, January 20, 2010 12:33 PM