sql job doesn't work

Hi all,

I create and schedule a SQL job to run every minute to update a table base on certain condition but it doesn't work. Job history says successful every time but the table doesn't get updated.

However if I move it to Query Analyzer and run it under dba, it will work. Thinking that it may have to do with the user the job run as, I then change run as user from self to dba. But still SQL job won't update my table.

Anything about user permission or security that I can check? Or it there any other possibility?

TIA

Not knowing what you are attempting to do I have to ask why you are not using table Triggers to do this action? Who is the job set to execute as? Try logging on as that user and see if you can perform those steps. If not adjust permissions accordingly.
...
Also verify that the job is set to run in the expected database. You could also have the job send notifiatications on failures and completions until you have identified the issue.