Scheduler Mystery

I have a scheduled job that executes sql to dump tran with no log. I have i
t
running at night so no users are affected. The next morning the job says it
succeded with no errors accounted for. However I have checked the size of
the ldf and it is huge. Our server space is getting smaller and smaller
every day, so I am suspect that the log file is not being truncated. When I
checked the SQL server event viewer, it shows an Error application event whe
n
the truncate process is started. Can anyone tell me why the scheduled job
shows a successfull run, while the event viewer tells another story?What version of SQL Server?

>I have a scheduled job that executes sql to dump tran with no log.
As of 7.0, we use BACKUP instead of DUMP, but DUMP is still allowed. Anyhow,
this doesn't shrink
physical file size. Are you doing regular transaction log backups? If nor, u
se simple recovery
model. If you are, don't just cut the log as it will break the log backup se
quence.
As for shrinking the file size, I've listed a number of articles in this art
icle:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Toco" <Toco@.discussions.microsoft.com> wrote in message
news:723A119C-5D64-4C36-9865-9BD8FBAF2775@.microsoft.com...
>I have a scheduled job that executes sql to dump tran with no log. I have
it
> running at night so no users are affected. The next morning the job says
it
> succeded with no errors accounted for. However I have checked the size of
> the ldf and it is huge. Our server space is getting smaller and smaller
> every day, so I am suspect that the log file is not being truncated. When
I
> checked the SQL server event viewer, it shows an Error application event w
hen
> the truncate process is started. Can anyone tell me why the scheduled job
> shows a successfull run, while the event viewer tells another story?

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.
>>
>