I created a JOB to run a simple package that runs a query and saves the results to an Excel file. If I try to run the job In SQL Management Studio I get an error saying:
SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022).
I made sure that SQLServerAgent was in fact running and tried running the job again (from SQL Managment Studio) but still got the same message.
I found this knowledge base article which is telling me that I have to edit the Registry in order to resolve the problem.
Before I go in and start messing with the registry which is something I really don't want to do I was wondering if anyone else has experienced this problem and if they had to edit their registry to fix it?