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

• jtodd 60645

  SSC Enthusiast

  Points: 180

  More actions

  July 25, 2013 at 11:21 am

  #1635846

  Thanks.

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

  Date7/25/2013 2:19:47 PM

  LogJob History (DBA-SQL Monitor - Report Whats Running Now)

  Step ID0

  ServerAGV-SQLLAB

  Job NameDBA-SQL Monitor - Report Whats Running Now

  Step Name(Job outcome)

  Duration00:00:00

  Sql Severity0

  Sql Message ID0

  Operator Emailed

  Operator Net sent

  Operator Paged

  Retries Attempted0

  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

  More actions

  July 25, 2013 at 11:23 am

  #1635847

  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

  More actions

  July 25, 2013 at 11:30 am

  #1635850

  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

  More actions

  July 25, 2013 at 11:46 am

  #1635855

  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