Re: Clearing Out DTS Package Logs
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
One option is to write your own maintenance of these using
the DTS Object Model and schedule this through a job. Take a
look at the RemovePackageLogRecords method of the
PackageSQLServer object. In terms of duration,, the package
log date is tied to the PackageLogRecord object.
-Sue
On Wed, 15 Aug 2007 08:02:02 -0700, JDS
<JDS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have a sql server sp4 that has about 910 DTS packages with package logging.
I'm not certain if all the packages have package logging but many do.
The issue we are having is that these logs are beginnning to fill up the
msdb database. Is there a way to schedule a package, run a script,or is
there an app to delete these logs based on a certain duration rather going
into each package and deleting them manually?
.
Relevant Pages
- SSIS Scheduling Failure - AcquireConnection Error
... package into SSIS services in Management Studio and ran the job manually. ... I got the dreaded 'AcquireConnection' error when I tried to schedule ... while logged onto the SQL Server 2005 database server itself. ... the 'SQL Agent Service Account'. ...
(microsoft.public.sqlserver.dts) - Re: Privilege in scheduling packages through sql agent jobs
... > How to Run a DTS Package as a Scheduled Job ... >>A programmer can schedule jobs through sql agent and the job step that is ... >>programmer runs the package interactively, ... >>attempts to schedule a package as sql agent job, ...
(microsoft.public.sqlserver.security) - Re: Odds n ends, part II
... up mostly just being about the schedule. ... Genuine SB (FSB for now) is back, which everyone pretty much knew had to be part of any package that the factories would underwrite. ... The second has only one literbike class, which is what the Japanese factories favor, but SB would be dumbed down, the mentioned stock components required being forks and swing arms, and no alternate gear ratios. ... He makes it sound like electronics may have to be stock as well, which creates issues when bikes like the 1098R are allowed into the class (that bike including a race kit as part of the stock package). ...
(rec.motorcycles.racing) - Re: DTS job error
... the DTS schedule package functionality - you right click on ... the package on select Schedule Package. ... DTSRUN /~Zxxxxxxxxxxxx. ...
(microsoft.public.sqlserver.server) - Re: Microsoft Visual C#
... That got me a bit concerned because the package is no good to me without the import from excel function. ... package our company uses for project cost estimating. ... To import a schedule of items from an Excel spreadsheet, ... Using a database of resources, assign these to individual items in the ...
(microsoft.public.dotnet.languages.csharp) |
|
