SQL Scheduled Job fails, but Query Analyzer runs the task complete

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davidtheweb - 19 Mar 2008 18:45 GMT

I have a Job on SQL that fails to kick off, but when I run the task (an index
defragmentation) under Query Analyzer with the same user credentials, it runs
fine. The Job wizard didn't ask for a password for the user login, and I
didn't see a place to enter it. Is there some other reason that has been
encountered that would cause this?

David

Reply to this Message

Linchi Shea - 19 Mar 2008 19:01 GMT

Did the job run at all? Or did it run but failed? What happens if you try to
start the job manually?

Linchi

> I have a Job on SQL that fails to kick off, but when I run the task (an index
> defragmentation) under Query Analyzer with the same user credentials, it runs
[quoted text clipped - 3 lines]
>
> David

Reply to this Message

Russell Fields - 19 Mar 2008 19:04 GMT

David,

In addition to Linchi's questions, also make sure that the schedule is not
disabled.

RLF

>I have a Job on SQL that fails to kick off, but when I run the task (an
>index
[quoted text clipped - 5 lines]
>
> David

Reply to this Message

davidtheweb - 19 Mar 2008 19:32 GMT

Found it! Under the Properties | Steps | Edit | Advanced tabs, I changed it
to Run as user: (Self) and the job ran properly.

Thanks for the answers

> David,
>
[quoted text clipped - 12 lines]
> >
> > David

Reply to this Message