Re: Job Scheduler fails and Managing Tempdb

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 15:10:59 +0100

Can you give an exact description of the problems you encounter with DTS.
You can turn logging on on both the job and the DTS Package to get some more
information about what goes wrong.

As I said in my previous post, shrinking tempdb is not very useful. It is
just that your server needs that much tempdb space, and eventually it will
have enough and not grow anymore. If it keeps growing, there is a problem
somewhere in one of your applications, maybe that transactions are kept open
indefinitely, and you will have to fix this problem. Cycling SQL Server on a
regular basis is not a good solution for any problem.

The commands you need btw are:
net start sqlserver
net stop sqlserver 

-- 
Jacco Schalkwijk
SQL Server MVP
"Richard Jolly" <rjolly@crgroup.com> wrote in message 
news:Oe5UsOKdEHA.644@tk2msftngp13.phx.gbl...
> Hi,
>
> I don't think its the permissions, as we are running as the domain
> administrator, which has been set to have access throughout everything
> including SQL Server.The failure of the job usually entails a few tables
> not being populated in a DTS package, however if the job is run manually
> or the DTS package is run the tables populate, we have no problems with
> Windows scheduler, which leads me to believe there is a general fault
> with SQL Server's SQL agent when it comes to automated runs. Other
> people seem to have the same problem.
>
> Is there away around this, as microsoft don't seem to have done anything
> about it in service pack3!
>
> The Tempdb growth, we can shrink it by stopping and starting the SQL
> service, we just need the command to do this "I think its net stop and
> net start, I'm not sure however".
>
> Thanks for your posting
>
> Regards,
>
> Richard Jolly
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: dts package and t log
    ... But isn't it possible to start a dts package and as the first step use some ... kind af statement to tell sql not to fill up ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > worth of t-log space. ...
    (microsoft.public.sqlserver.dts)
  • Re: Creating a DTS ActiveX Task
    ... (this is the service that runs jobs in SQL Server) ... the 'logon as' tab, you'll see what account this service runs as, this is ... from the network from your DTS package you'll be fine, ... > I'm not very familiar with SQL Server, I only know some VB and TSQL. ...
    (microsoft.public.sqlserver.programming)
  • Re: Batch File in DTS
    ... I assume that you are running SQL Server 2000. ... is run as a system administrator) or else of the SQL Agent proxy account. ... This works in DTS package, but when I schedule the package, ...
    (microsoft.public.sqlserver.dts)
  • Can a DTS Data Driven Query Task use a temporary binding table?
    ... I'd like to make a DTS package that leverages the Data Driven Query Task. ... source rows from an Excel spreadsheet will be calling an SP in my destination SQL Server ... that I'd need a task to initially *create* the table in tempdb, ...
    (microsoft.public.sqlserver.server)
  • Can a DTS Data Driven Query Task use a temporary binding table?
    ... I'd like to make a DTS package that leverages the Data Driven Query Task. ... source rows from an Excel spreadsheet will be calling an SP in my destination SQL Server ... that I'd need a task to initially *create* the table in tempdb, ...
    (microsoft.public.sqlserver.tools)