SQL LanguageSQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Hi
SQL Server Agent 2000 is started and should work but it does not execute jobs defined. jobs were executed every night in last 3 month and no problem was there. i had restart server, SQL Server, SQL Server Agent frequently. but it did not work. i had changed SQL Server and SQL Server Agent service account and it did not work either. when i want to start a job manually the error message appears: "Error 22022: SQL Server Agent Error: job 0xF7... does not exist in job cache". simply i don't get it.
well its weird but i fu sure ur agent is working fine & SQL is ok
lets do it again.
-create new job & run that, what happend?
what r u doing in that job? what do u call or execute?
Problem with SQL Server Agent
