question

jangi avatar image
jangi asked

SQL Agent job

Hi,


I am facing an issue with a SQL Agent job. It is executing while I am looking on Job monitor and when I see for the active sessions with sp_who2 and sp_whoisactive it shows nothing but on job monitor it shows it is executing from 2 days. I have executed sp_stop_job 'jobname' and it ran successfully but nothing change, then I see it is running on SSAS.


To show running queries, I have executed this MDX query :

SELECT * FROM $SYSTEM.DISCOVER_COMMANDS

order by command_start_time

GO

SELECT * FROM $SYSTEM.DISCOVER_SESSIONS

GO

SELECT * FROM $SYSTEM.DISCOVER_CONNECTIONS

GO


But it shows nothing though, now I see my options are closed.


Can anyone help here ?


Thanks in Advance

sql-server-agent
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.