Re: SQL Server Agent jobs - The specified @job_name does not exist.
From: Richard Waymire [MSFT] (rwaymi_at_online.microsoft.com)
Date: 11/10/03
- Next message: Quigley: "File based DSN's - Good or Bad ?"
- Previous message: Allan Mitchell: "Re: Finding SQL Servers and Patch levels on a network"
- In reply to: David Grant: "SQL Server Agent jobs - The specified @job_name does not exist."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 10 Nov 2003 10:04:05 +0100
I believe you're running into a known issue that there is a QFE for. Check
out this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;821334&Product=sql2k
--
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Grant" <david_i_a_grant@hotmail.com> wrote in message
news:0fca01c3a3fe$8e641450$a001280a@phx.gbl...
> Hello,
>
> I have an ASP.NET web application hosted on IIS 6.0, with
> NETWORK SERVICE as the ASP.NET account. The web app calls
> a stored procedure in the database which attempts to use
> msdb.dbo.sp_add_jobschedule to schedule a run of an SQL
> Server agent job. This job is owned by the dbo.
>
> However, I reive the error "The specified @job_name
> ('GlaBay_closeAuction') does not exist." whenever this
> stored procedure is executed.
>
> The only way I can get the procedure to execute is by
> running it in Query Analyzer when logged in as the dbo
> account which owns the job. Is it the case that only the
> job owner can add schedules? If so, how can I allow the
> NETWORK SERVICE account to do this, since it is a group
> login and cannot be selected as the job owner?
>
> Thanks,
>
> David Grant
- Next message: Quigley: "File based DSN's - Good or Bad ?"
- Previous message: Allan Mitchell: "Re: Finding SQL Servers and Patch levels on a network"
- In reply to: David Grant: "SQL Server Agent jobs - The specified @job_name does not exist."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
