What’s going on, on my server, right now?

  • jtodd 60645

    SSC Enthusiast

    Points: 180

    Thanks.

    now getting this and trying not to throw hands up in air.

    Date 7/25/2013 2:19:47 PM

    Log Job History (DBA-SQL Monitor - Report Whats Running Now)

    Step ID 0

    Server AGV-SQLLAB

    Job Name DBA-SQL Monitor - Report Whats Running Now

    Step Name (Job outcome)

    Duration 00:00:00

    Sql Severity 0

    Sql Message ID 0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted 0

    Message

    The job failed. The Job was invoked by User ARGUSGROUP\jtodd-a. The last step to run was step 1 (Run the Report). NOTE: Failed to notify 'Pinky' via email.

  • jtodd 60645

    SSC Enthusiast

    Points: 180

    sqlpanther, thank for your time.

    I'm now getting this error:

    Message

    Executed as user: NT AUTHORITY\LOCAL SERVICE. Cannot find the object "SP_Who_Results" because it does not exist or you do not have permissions. [SQLSTATE 42S02] (Error 4701)Unable to open Step output file. The step failed.

  • sqlpanther

    Ten Centuries

    Points: 1204

    Check your Truncate command and add

    USE [SQL_Monitoring] -- if this is the DBname u specified,everything looks good else.

  • jtodd 60645

    SSC Enthusiast

    Points: 180

    sqlpanther.

    Thanks for helping.

    I can't see anything wrong with this:

    --clean up sp_who

    USE [SQL_Monitoring]

    Truncate table [SP_Who_Results]

    --run SP_Who

    Use [SQL_Monitoring]

    Insert into [SP_Who_Results]

    execute sp_who

Viewing 4 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply