Re: Sql server scheduled job failed

Tech-Archive recommends: Speed Up your PC by fixing your registry

anonymous_at_discussions.microsoft.com
Date: 03/24/04 

Date: Wed, 24 Mar 2004 12:53:37 -0800

This is the error message, I am getting
Executed as user: USTMSW\sps.admin. An error occurred
while preparing a query for execution against OLE DB
provider 'ADSDSOObject'. [SQLSTATE 42000] (Error 7321).
The step failed.

shalini
>-----Original Message-----
>Check job history, make sure you check the "show step
details" checkbox (or you won't see the error messages)
>and post back the error messages from the filed jobstep.
>
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>
>"Shalini" <shalini.ashokan@tmsw.com> wrote in message
news:12d1901c411de$e11554e0$a501280a@phx.gbl...
>> We have scheduled a job to run a query in our SQL
database
>> SP_PollAD_AllDomains. It was working fine. From
yesterday
>> job is not running , it is getting failed.Any
>> idea,thoughts why?
>
>
>.
>

Relevant Pages

  • Re: Sql server scheduled job failed
    ... > while preparing a query for execution against OLE DB ... >>and post back the error messages from the filed jobstep. ... >>Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Job owned by a non-sysadmin fails to run
    ... You mentioned earlier that you looked at the job for error messages. ... This could be due to a different environment or the way the program retrieves configuration information under the different execution contexts. ... SQL Server MVP ... this executable runs fine if I login interactively as user as well as sqlproxy and execute it from the command line. ...
    (microsoft.public.sqlserver.security)
  • Re: Capturing Error Message Text
    ... I took a look at the articles you suggested and it ... execution is transferred to the CATCH block. ... The problem I am having is that the error messages ... >> displayed had I ran these queries in Query Analyzer. ...
    (microsoft.public.sqlserver.programming)
  • IIS 6 + ASP problems
    ... If you have turned off friendly error messages, ... >I have this strange thing happening with my asp pages. ... win2003 server std. ... >execution after x+1 records, the page fails. ...
    (microsoft.public.inetserver.iis)
  • RE: Disappearing data in sub-form
    ... Are you receiving any error messages, or do you see any status bar ... If the subform is based on a query, is the query updateable and can you ... box is likely unbound (ie. it has no Control Source specified). ...
    (microsoft.public.access.forms)