locked
Log files RRS feed

  • Question

  • 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

  • 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
  • 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

  • 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
  • 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