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, canadaHI
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...
> 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...
> > 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
>
>|||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...
> > 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.
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...
> > 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
>
>|||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...
> ============================================> 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...
>> > 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
>>|||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...
> > ============================================> > 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...
> >> > 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
> >>
> >>
> >>
>
>