Scheduled job is not running successfully. Event ID: 208

SQL server standard edition version 8.00.2039 [SP4] on MSWindows NT 5.2
[3790] .
We have a procedure that is scheduled to run every night . It is running
fine for last few months. Last week it stopped running successfully. In
application event log we are getting warning message:
====================================
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Date:6/12/2007
Time:4:23:19 AM
User:N/A
Computer:computername1
Description:
SQL Server Scheduled Job 'abcd-Daily 1' (0xC456F221DE41D5469B869BA1657DDDC0)
- Status: Failed - Invoked on: 2007-06-12 04:00:00 - Message: The job failed.
The Job was invoked by Schedule 6 (6.x schedule). The last step to run was
step 1 (Step 1).
====================================
No error message in sql server errorlog.
ontario, canada
============================================
Its a permission error in step1.
Executed as user: username. SELECT permission denied on object
'a_bb_REQUEST_RESOURCE', database 'databasename', owner 'dbo'. [SQLSTATE
42000] (Error 229). The step failed.
============================================
ontario, canada
"vt" wrote:

> HI
> Do this
> Enterprise manager->Management->sql Server agent->jobs
> select your job and click the job history from the drop down menu
> this will open up job history dialog box, click the show step details, you
> can see the actual error message there, post that error message
> Regards
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "db" <db@.discussions.microsoft.com> wrote in message
> news:DA7F4D29-8754-4A40-ABAD-AEFE4890BB41@.microsoft.com...
>
>
|||It points to permission error.
Executed as user: abc. SELECT permission denied on object
'a_bb_REQUEST_RESOURCE', database 'databasename', owner 'dbo'. [SQLSTATE
42000] (Error 229). The step failed.
ontario, canada
"vt" wrote:

> HI
> Do this
> Enterprise manager->Management->sql Server agent->jobs
> select your job and click the job history from the drop down menu
> this will open up job history dialog box, click the show step details, you
> can see the actual error message there, post that error message
> Regards
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "db" <db@.discussions.microsoft.com> wrote in message
> news:DA7F4D29-8754-4A40-ABAD-AEFE4890BB41@.microsoft.com...
>
>
|||Its a permission error.
Executed as user: abc. SELECT permission denied on object
'a_bb_REQUEST_RESOURCE', database 'databasename', owner 'dbo'. [SQLSTATE
42000] (Error 229). The step failed.
ontario, canada
"vt" wrote:

> HI
> Do this
> Enterprise manager->Management->sql Server agent->jobs
> select your job and click the job history from the drop down menu
> this will open up job history dialog box, click the show step details, you
> can see the actual error message there, post that error message
> Regards
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "db" <db@.discussions.microsoft.com> wrote in message
> news:DA7F4D29-8754-4A40-ABAD-AEFE4890BB41@.microsoft.com...
>
>
|||It worked. Thanks vt.
ontario, canada
"Vt" wrote:

> Hi
> ok..Now give the proper permission and try..
>
> Regards
> Vt
> Knowledge is power;Share it
> http://oneplace4sql.blogspot.com
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:9AE94423-FD7C-4552-BFB5-4EDA062914D8@.microsoft.com...
>
>