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
SELECT * FROM $SYSTEM.DISCOVER_SESSIONS
SELECT * FROM $SYSTEM.DISCOVER_CONNECTIONS
But it shows nothing though, now I see my options are closed.
Can anyone help here ?
Thanks in Advance