Agent not showing in SSMS
-
I have remote server. Checked it this morning and I can't see SQL Agent in SSMS.
I have stopped and restarted both the SQL Service & The Agent Service.
Version is Standard.
Agent service shows as running, but is not in SSMS. What the...?
-
The only posibility then that I am aware of is that the account your loging in as isn't sysadmin or a member of the SQL Agent fixed roles.
-
yeah it was a rights thing...
thanks for your help..
-
Hi, I have the same problem as above and its def priv related as i tightened security on my db yest and no wmy sql server agent jobs dont complete running (they dont error either. Also when i create a new one i get 'sql server agent job not chached'.
Does anybody know what may be lacking matching/correct permissions - server, db, tables, agent?
Any advise will do as I know this is a small issue but im flummoxed (spelling)
ferg
-
found solution, i was not a sa anymore so sql server agent refsed to run under me or indeed run any jobs where i was given as user account.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply