SQL Server Troubleshooting
Agent: Never started ... and won't start
An agent has the status ‘Never started’ and whilst it can
be told to start it doesn't run and the status never change from ‘Never
started’. This can affect Snapshot Agents, Log Reader Agents, Distribution
Agents, Merge Agents or Miscellaneous Agents.
The owner of the job (who is probably the user who created
the job or who first set up replication) does not have the necessary permissions.
Review whether the current owner of the job is appropriate.
- Grant the owner the necessary permissions.
- Change the owner to a more suitable account (for example
SQLServerAgent assuming that account was created when SQL Server was
The owner of the job is shown under ‘Agent Properties’.
These notes are believed to be correct for SQL
Server 7 and may apply to other versions as well.
About the author: Brian Cryer
is a dedicated software developer and webmaster. For his day job he
develops websites and desktop applications as well as providing
IT services. He moonlights as a technical author and consultant.