For a while now we have been running SQL for our ERP system.
Recently i have noticed that a rebuild indexes task has not been running on the SQL database.
On closer inspection, i noticed that the SQL server agent is not running - when i try and start the service it tells me 'windows could not start the service - error 2: the system cannot find the file specified.
I have taken a look at some posts already which refer the checking the location of the sqlagent.out log file path in the registry.
This would all appear ok - but when i try to start the service this file is not updating....
I have also tried renaming the file to see if a new file is create but nothing happens....
Any advice or pointers that could be given would be greatly appreciated.