Scheduled job fails when old db's offline

I have a SQL Server 2000 db, that has db's unrelated to an application that
I run some sql server scheduled tasks. I decided I wanted to dump these old
db's, so the first step is to take the db's offline for a week before
deleting them. Well for some reason all tasks for an unrelated (?) system
would fail and until I brought these unconnected db's back online they
wouldn't run.
If I went into dts and run the apps they run fine, the Id is my elevated
domain admin account. The sql server agent that runs the task is a domain
account with local admin privileges.
Is there something I can check for to try and get more info? Nothing in the
sql logs, in the Event logs this is all I get. Stumped?
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 10/9/2007
Time: 11:02:10 AM
User: N/A
Computer: some_SQL
Description:
SQL Server Scheduled Job 'Extract_Command_Center_Meters'
(0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by User
some_domain\some_admin. The last step to run was step 1
(Extract_Command_Center_Meters 2).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.SQL Agent itself doesn't care about what dbs are on or offline. But the job
obviously does so I would start there. Look in the DTS package to see where
it references these databases. You can also try looking at the job step
itself in the job history. You will need to expand the history listing to
see the individual steps.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
news:uWt8T$oCIHA.4228@.TK2MSFTNGP02.phx.gbl...
>I have a SQL Server 2000 db, that has db's unrelated to an application that
>I run some sql server scheduled tasks. I decided I wanted to dump these
>old db's, so the first step is to take the db's offline for a week before
>deleting them. Well for some reason all tasks for an unrelated (?) system
>would fail and until I brought these unconnected db's back online they
>wouldn't run.
> If I went into dts and run the apps they run fine, the Id is my elevated
> domain admin account. The sql server agent that runs the task is a domain
> account with local admin privileges.
> Is there something I can check for to try and get more info? Nothing in
> the sql logs, in the Event logs this is all I get. Stumped?
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 10/9/2007
> Time: 11:02:10 AM
> User: N/A
> Computer: some_SQL
> Description:
> SQL Server Scheduled Job 'Extract_Command_Center_Meters'
> (0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
> 2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by
> User some_domain\some_admin. The last step to run was step 1
> (Extract_Command_Center_Meters 2).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> --
> Paul Bergson
> MVP - Directory Services
> MCT, MCSE, MCSA, Security+, BS CSci
> 2003, 2000 (Early Achiever), NT
> http://www.pbbergs.com
> Please no e-mails, any questions should be posted in the NewsGroup
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Done that already. Dang... I just am truly stumped.
As you notice it will run if done directly from the DTS editor.
--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23VSwWdpCIHA.464@.TK2MSFTNGP02.phx.gbl...
> SQL Agent itself doesn't care about what dbs are on or offline. But the
> job obviously does so I would start there. Look in the DTS package to see
> where it references these databases. You can also try looking at the job
> step itself in the job history. You will need to expand the history
> listing to see the individual steps.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
> news:uWt8T$oCIHA.4228@.TK2MSFTNGP02.phx.gbl...
>>I have a SQL Server 2000 db, that has db's unrelated to an application
>>that I run some sql server scheduled tasks. I decided I wanted to dump
>>these old db's, so the first step is to take the db's offline for a week
>>before deleting them. Well for some reason all tasks for an unrelated (?)
>>system would fail and until I brought these unconnected db's back online
>>they wouldn't run.
>> If I went into dts and run the apps they run fine, the Id is my elevated
>> domain admin account. The sql server agent that runs the task is a
>> domain account with local admin privileges.
>> Is there something I can check for to try and get more info? Nothing in
>> the sql logs, in the Event logs this is all I get. Stumped?
>> Event Type: Warning
>> Event Source: SQLSERVERAGENT
>> Event Category: Job Engine
>> Event ID: 208
>> Date: 10/9/2007
>> Time: 11:02:10 AM
>> User: N/A
>> Computer: some_SQL
>> Description:
>> SQL Server Scheduled Job 'Extract_Command_Center_Meters'
>> (0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
>> 2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by
>> User some_domain\some_admin. The last step to run was step 1
>> (Extract_Command_Center_Meters 2).
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>>
>> --
>> Paul Bergson
>> MVP - Directory Services
>> MCT, MCSE, MCSA, Security+, BS CSci
>> 2003, 2000 (Early Achiever), NT
>> http://www.pbbergs.com
>> Please no e-mails, any questions should be posted in the NewsGroup
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>|||I had have the very same problem with a customer, they disabled the user
account which was the owner of the job and they were getting exactly the
same error...
--
Ekrem Önsoy
"Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
news:Oq9f%23fqCIHA.4752@.TK2MSFTNGP04.phx.gbl...
> Done that already. Dang... I just am truly stumped.
> As you notice it will run if done directly from the DTS editor.
> --
> Paul Bergson
> MVP - Directory Services
> MCT, MCSE, MCSA, Security+, BS CSci
> 2003, 2000 (Early Achiever), NT
> http://www.pbbergs.com
> Please no e-mails, any questions should be posted in the NewsGroup
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23VSwWdpCIHA.464@.TK2MSFTNGP02.phx.gbl...
>> SQL Agent itself doesn't care about what dbs are on or offline. But the
>> job obviously does so I would start there. Look in the DTS package to see
>> where it references these databases. You can also try looking at the job
>> step itself in the job history. You will need to expand the history
>> listing to see the individual steps.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
>> news:uWt8T$oCIHA.4228@.TK2MSFTNGP02.phx.gbl...
>>I have a SQL Server 2000 db, that has db's unrelated to an application
>>that I run some sql server scheduled tasks. I decided I wanted to dump
>>these old db's, so the first step is to take the db's offline for a week
>>before deleting them. Well for some reason all tasks for an unrelated
>>(?) system would fail and until I brought these unconnected db's back
>>online they wouldn't run.
>> If I went into dts and run the apps they run fine, the Id is my elevated
>> domain admin account. The sql server agent that runs the task is a
>> domain account with local admin privileges.
>> Is there something I can check for to try and get more info? Nothing in
>> the sql logs, in the Event logs this is all I get. Stumped?
>> Event Type: Warning
>> Event Source: SQLSERVERAGENT
>> Event Category: Job Engine
>> Event ID: 208
>> Date: 10/9/2007
>> Time: 11:02:10 AM
>> User: N/A
>> Computer: some_SQL
>> Description:
>> SQL Server Scheduled Job 'Extract_Command_Center_Meters'
>> (0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
>> 2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by
>> User some_domain\some_admin. The last step to run was step 1
>> (Extract_Command_Center_Meters 2).
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>>
>> --
>> Paul Bergson
>> MVP - Directory Services
>> MCT, MCSE, MCSA, Security+, BS CSci
>> 2003, 2000 (Early Achiever), NT
>> http://www.pbbergs.com
>> Please no e-mails, any questions should be posted in the NewsGroup
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>