Error 14262 The Specified @job
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about
The Specified @proxy_name Does Not Exist.
Stack Overflow the company Business Learn more about hiring developers or posting ads with sp_verify_job_identifiers sql server us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top The specified @job_id does not exist up vote 1 down vote favorite 1 After deleting a SQL Server Agent job I continue to get notifications that the job attempted to run and failed. I am receiving the following error message. [000] Unable to retrieve steps for job my_job [298] SQLServer Error: 14262, The specified @job_id ('CC65FEFB-0033-442E-B55E-6209E25C5039') does not exist. [SQLSTATE 42000] I have checked the following tables in the msdb database and none of them have the specified job_id except the dbo.sysjobhistory table. dbo.sysjobs dbo.sysjobschedules dbo.sysjobsteps dbo.sysjobstepslogs dbo.sysjobservers dbo.sysjobactivity dbo.sysjobhistory Is there anywhere else I can look? Also, today I have stopped and restarted the SQL Server Agent and will update this post tomorrow with the result. Thank you in advance! sql-server sql-server-agent share|improve this question asked Oct 9 '13 at 19:52 KenWilson 352311 3 Start a trace for calls to sp_start_job - you should catch the offender pretty quickly. –Aaron Bertrand♦ Oct 9 '13 at 20:10 Additional information being requested on twitter so I thought I would add it here. Q: "anything in codebase/schedule task calling sp_start_job?" A: No –KenWilson Oct 9 '13 at 20:11 @AaronBertrand I will set that up tonight! Thanks. –KenWilson Oct 9 '13 at 20:12 How about sp_delete_job @job_id = ? Also, any replication involved ? –Kin Oct 9 '13 at 20:13 Additional information being requested on twitter. Q:"what build of SQL Server?" A:"SQL Server 2008 R2 SP1 (10.50.2425)" –KenWilson Oct 9 '13 at 20:13 | show 3 more comments 1 Answer 1 active oldest votes up vote 0 down vote accepted A st
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums Old Forums CLOSED - General SQL Server Job HELL - Please help Forum Locked Printer Friendly Author Topic Edmund Starting Member 4 Posts Posted-01/02/2003: 10:21:40 HelloI have users that access a database through a user group. There is a stored procedure that http://dba.stackexchange.com/questions/51290/the-specified-job-id-does-not-exist I have set up to run through a job because it takes quite a while. The user is notified through SQL Mail.Now ...sp_start_job will only run jobs that the user owns for users not in sysadmin. Therefore I have followed the SQL documentation and used xp_sqlagent_proxy_account to set up the domain administrator, who is a member of sysadmin, as the SQL Server Agent proxy account. Then I set the job's owner as the domain http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=22715 administrator. According to the SQL documentation users who are not members of sysadmin will default to using the account set up with xp_sqlagent_proxy_account. Since the domain administrator is a member of sysadmin and has been set as the job's owner one would think that there would be no problem getting the job running with sp_start_job for thoes users who are not in sysadmin.However I get the following when users try to run the job from the applicaton:Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61The specified @job_name ('My Job X') does not exist.Please help me. Please, please, PLEASEMany thanksEdmund Edmund Starting Member 4 Posts Posted-01/02/2003: 12:25:07 I recieved the following response from the microsoft news server:==========================================Hi Edmund, xp_sqlagent_proxy_account only applies once the job is running. As per BOL:"When the user is not a member of the sysadmin fixed server role, sp_start_job will impersonate the SQL Server Agent proxy account, which is specified using xp_sqlagent_proxy_account."It does not affect a user's ability to start a job. The following still holds true irrespective of xp_sqlagent_proxy_account (as per BOL):"A user who is not a member of the sysadmin role can use sp_start_job to start only the jobs he/she owns."No way to get around this I'm afraid. Only sysadmin's and / or job owners can start jobs (irrespective of the ownership
your question and get tips & solutions from a community of 418,504 IT Pros & Developers. It's quick & easy. SQL agent Error https://bytes.com/topic/sql-server/answers/936363-sql-agent-error-critical - Critical P: 1 Pin2saran Hi , i have got a problem http://www.tek-tips.com/viewthread.cfm?qid=438926 in my environment, The SQL server Agent errror logs is continously filled up with below error messages "[298] SQLServer Error: 14262, The specified @job_id ('74AF9B09-0C54-449E-8BDC-3D323D570D1F') does not exist. [SQLSTATE 42000] (ConnExecuteCachableOp" After several research, i got to know that EXEC sp_delete_job @job_id='74AF9B09-0C54-449E-8BDC-3D323D570D1F' statement is running contionously at background , which is the specified making these error messagges entries. I even restarted the SQL Agent service , but still not helped. Please guide me in resolving this problem. thanks in advance. Mar 20 '12 #1 Post Reply Share this Question 2 Replies Expert 2.5K+ P: 2,878 ck9663 You might want to check first why there's a delete job running. If you are certain that it is not needed, error 14262 the disable that job first and see what happens. Good Luck!!! ~~ CK Mar 20 '12 #2 reply Expert Mod 100+ P: 465 PsychoCoder Read through the comments in this post, it may solve your issue. Mar 24 '12 #3 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics Where is the error in this code? Identity range managed by replication is full and must be updated by a replication agent. Error Message Makes NO SENSE. Error while loading an XML file from Agent via SS Javascript ASP SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases What is Expressiveness in a Computer Language Error while connecting to DB2 Z/OS from DataStage Can't Auto-Start Agent HELP NEEDED for Internal error 0xFFFFF707 which cause DB to go Crash Recovery SQL1224N A database agent could not be started to service a request SQL Mail and SQL Agent Mail @!~$%!%#^$%&^#% Browse more Microsoft SQL Server Questions on Bytes Question stats viewed: 3168 replies: 2 date asked: Mar 20 '12 Follow this discuss
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft SQL Server: Programming Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft SQL Server: Programming Forum Job Permissions - ODBC Error 14262 thread183-438926 Forum Search FAQs Links MVPs Job Permissions - ODBC Error 14262 Job Permissions - ODBC Error 14262 SarahG (Programmer) (OP) 3 Jan 03 07:04 I have a job set up on SQL Server 7 whose owner is set to be the NT account which runs the SQL Server service.I have a stored procedure which runs this job (using sp_start_job). I have an access 2000 db which calls this sp (exec sp_start_job @job_name='TestJob').The sp & consequently the job are run with no errors from access when I am logged in.However, when another user is logged in I get an error message :[Microsoft][ODBC SQL Server Driver][SQl Server]The specified @job_name(‘TestJob’) does not exist. (#14262)This is obviously related to permissions, but what am I doing wrong? I know I can work around this by having the sp call a batch file which starts the job via isql, but there must be an easier way!!What must I do to allow a regular user to run sp_start_job from a stored procedure? RE: Job Permissions - ODBC Error 14262 JamesLean (Programmer) 3 Jan 03 07:33 The problem is with the owner of the stored proc, not the job.I am assuming the owner of the SP is your login (SarahG?) and not dbo?If t