Job requirements

This is taken directly from a job requirement (names are not mentioned to protect the ignorent...I meant Innocent):

The employee must occasionally lift and/or move up to 25 pounds. While performing the duties of this job, the employee is frequently required to stand; walk; sit; talk or hear; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl.Wow. I didn't realize that the L.A. "freeze" on the adult industry had had that much effect across the country!

-PatP|||The part about "Stoop, crouch, kneel, and crawl" only applies at performance review time.|||OmG you guys...thats too funny.|||By the way, the requirements in the original post apply to an existing job opening for Senior SQL Server DBA, so don't make any mistake, - it is not for construction worker or anything ;)


The difficult ones I find are of course the ones that relate to the review time, though I am not sure that those abilities need to be demonstrated while having to hear or talk ;)|||There's a lesson to be learned here: never ever become a senior! :)|||never ever become a senior! :)or seniorita, as the case may be

Job fails to communicate with SQL Server Agent

Hi,

Just need some help on a job issue.

The job in question gives the below mentioned error when run

Error 22022: Unable to post notification to SQL
ServerAgent (reason: OpenFileMapping()returned error
2, 'The system cannot find the file specified')

This seems to have started after I changed the owner for the Agent and MSSQL service from local service to a domain ID.

FYI, I have also changed the job owner from sa to the domain ID and have tried restarting the agent service in the hope that the Job can speak to the agent .. but it doesnt :(

Microsoft suggests to change some registry entries but I am not sure if that'd work
http://support.microsoft.com/default.aspx?scid=kb;en-us;911841&sd=rss&spid=2852

The server on which this job is hosted is a production box .. so am a litle apprehensive about making any registry changes

Any Suggestions ?

Thanks.

Warm Regards,
Ranjit.Hi people ...

Getting no instant fixes to this issue, I changed the service owner back to local system ... But on doing so .. things took a bad turn and the agent got hung .. we had no option but to call for an emergency reboot ..

That fixed the issue as the agents were set back to their usual settings.

I am still hunting for a permanant solution on this.. so would appreciate any help on this.

Thanks,
Ranjit.|||How did you change the accounts under which Agent & Server services are running? You must do it only via Enterpr. manager, not Windows services.