How do I write a job to delete the old backup files. I do not want to use
Maintenance plan. I would like to write a sql job to perform this activity.
Is there any procedure for this
ThanksHi,
Have a look into the old post:-
http://groups.google.co.in/group/microsoft.public.sqlserver.server/browse_thread/thread/49bf865107573571/93d87002b75a5a0f?q=sql+server+script+to+delete+old+backup+files&rnum=6&hl=en#93d87002b75a5a0f
Thanks
Hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:256D7D14-D04F-4195-A065-CA920A1F9AC6@.microsoft.com...
> How do I write a job to delete the old backup files. I do not want to use
> Maintenance plan. I would like to write a sql job to perform this
> activity.
> Is there any procedure for this
> Thanks
Showing posts with label activity. Show all posts
Showing posts with label activity. Show all posts
Friday, March 30, 2012
Wednesday, March 7, 2012
Job Activity Monitor
Is there any way to modify the layout of the Job Activity Monitor?
After I resize columns and/or the size of the window, when I close the window it does not save. 
I assume this is a "feature". Any plans on fixing this?
Thanks!!!
I agree, you open the Job activity monitor, size the screen exactly how you like it, widen the left pane so you can see the job names in full, pull up the splitter so you can see more of the history details and less of the job runs, and then you close the window and lose it all and have to start again. Very very annoying.|||No, this is not possible. This would be a good suggestion to file on Microsoft Connect: http://connect.microsoft.com/SQLServer/Feedback/.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Job Activity Monitor
Hi,
I have a problem with Job Activity Monitor.
I have a SSIS which copies data from a table to a flat file. The connection string of this file is variable and the file is reused if not exists and is created if exists.
When I run the SSIS manually from my microsoft visual studio it works properly. However, when I run this SSIS from the Job Activity Monitor, I get the following error:
Message
Executed as user: REDCAM\adminsql2k5. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:41:10 AM Error: 2007-09-10 08:48:04.99 Code: 0xC020200E Source: Crear Historico Historico [1] Description: Cannot open the datafile "\\srvnfile\HISTORICOS\CAJEROS\OFI3210C01\OFI3210C01_2007-7X.txt". End Error Error: 2007-09-10 08:48:04.99 Code: 0xC004701A Source: Crear Historico DTS.Pipeline Description: component "Historico" (1) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:41:10 AM Finished: 8:48:53 AM Elapsed: 462.234 seconds. The package execution failed. The step failed.
Any idea?
Thanks.
Does the SQL Server service account have access to \\srvnfile\HISTORICOS?|||Yes the SQL Server service account have access to \\srvnfile\HISTORICOS.
|||Did you find the resolution to this issue?
|||Had the same problem - found this ans in sql server central.Are you running SQL Server agent using a local account on the SQL box? If so, you'll have problems copying the file out to a network share. If this is the case, try restarting SQL Server Agent using a domain account that has write access to that share. (Tim)
That wasn't my problem. I used a mapped drive. (my perspective) Don't do that.
Job Activity Monitor
Is there any way to modify the layout of the Job Activity Monitor?
After I resize columns and/or the size of the window, when I close the window it does not save.
I assume this is a "feature". Any plans on fixing this?
Thanks!!!
I agree, you open the Job activity monitor, size the screen exactly how you like it, widen the left pane so you can see the job names in full, pull up the splitter so you can see more of the history details and less of the job runs, and then you close the window and lose it all and have to start again. Very very annoying.|||No, this is not possible. This would be a good suggestion to file on Microsoft Connect: http://connect.microsoft.com/SQLServer/Feedback/.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Job Activity Monitor
Hi,
I have a problem with Job Activity Monitor.
I have a SSIS which copies data from a table to a flat file. The connection string of this file is variable and the file is reused if not exists and is created if exists.
When I run the SSIS manually from my microsoft visual studio it works properly. However, when I run this SSIS from the Job Activity Monitor, I get the following error:
Message
Executed as user: REDCAM\adminsql2k5. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:41:10 AM Error: 2007-09-10 08:48:04.99 Code: 0xC020200E Source: Crear Historico Historico [1] Description: Cannot open the datafile "\\srvnfile\HISTORICOS\CAJEROS\OFI3210C01\OFI3210C01_2007-7X.txt". End Error Error: 2007-09-10 08:48:04.99 Code: 0xC004701A Source: Crear Historico DTS.Pipeline Description: component "Historico" (1) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:41:10 AM Finished: 8:48:53 AM Elapsed: 462.234 seconds. The package execution failed. The step failed.
Any idea?
Thanks.
Does the SQL Server service account have access to \\srvnfile\HISTORICOS?|||Yes the SQL Server service account have access to \\srvnfile\HISTORICOS.
|||Did you find the resolution to this issue?
Job activity = slow, non job = fast
I have created an integration services package with a script-source reading data from Active directory. Pretty much data is read and written into a sql2005 database.
I have notised that when I run the package via right-clicking the package (Under stored packages\MSDB) and selecting "Run Package" it takes about 45 minutes for it to complete successfully. The same goes if I run the package from inside Visual Studio. However, when I create a job and put this package as one of it's tasks the task takes about 1h 40min. This is more then double the time! In neither case the server is occupied with soething else. And I have tried it several times so it wasn't just an "accident".
Any ida of what this depends on?
regards Andreas
I don't know the answer but I have exactly the same happening for a package I've just created that just copies data from an Ingres database to SQL Server.
Visual studio 45 mins, scheduled job 2 hrs 5 mins
Shocking!
|||You both have conflicting results, so here are some points to think about.
Visual Studio includes debugging, which is slower. You can run without, Ctrl+F5. This should be faster than the default F5 execution behaviour. Debugging can have a high overhead due to all the extra messages. Excessive logging can also have an impact, this is similar to debugging in many resects due to the extra chatter going on to give progress information.
Unless the Visual Studio session and the SQL Server Agent used for the job are on the same local machine, there is a change in execution location between the two methods. This can have a significant impact on performance depending on your source and destination locations. Data may have to travel over the network to the server or workstation, and this can vary greatly.
|||Wicket wrote:
I have created an integration services package with a script-source reading data from Active directory. Pretty much data is read and written into a sql2005 database.
I have notised that when I run the package via right-clicking the package (Under stored packages\MSDB) and selecting "Run Package" it takes about 45 minutes for it to complete successfully. The same goes if I run the package from inside Visual Studio. However, when I create a job and put this package as one of it's tasks the task takes about 1h 40min. This is more then double the time! In neither case the server is occupied with soething else. And I have tried it several times so it wasn't just an "accident".
Any ida of what this depends on?
regards Andreas
That sounds strange. What happens if you execute the package using dtexec.exe?
If it works quicker using dtexec (which I would expect) then use a command-line sub-step in the Agent job rather than the SSIS sub-step. In fact you should be doing this anyway because you get more debugging information. There's an article about this on wiki.sqlis.com but that site is down at the moment so I can't link to it.
-Jamie
:
|||
Is this the article you mean-
Comparing Overhead On The Execution Methods
(http://www.sqlis.com/default.aspx?84)
I think the main site and wiki are both up, although with my internet connection quality today they may was well not be.
|||I'm running Visual Studio on the server itself, not a workstation, so I'm not hopping round the network when running the package from VS but that's beside the point isn't it?
I've stored the package in msdb, scheduled it to run using an agent job using the SQL Server service acount and it takes nearly 3 times as long, I'd expected it to run slow in VS but not as a scheduled job.
Is this the article you mean-
Comparing Overhead On The Execution Methods
(http://www.sqlis.com/default.aspx?84)I think the main site and wiki are both up, although with my internet connection quality today they may was well not be.
No. I mean this one: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html (site is up now)
-Jamie
|||
I'm running Visual Studio on the server itself, not a workstation, so I'm not hopping round the network when running the package from VS but that's beside the point isn't it?
I've stored the package in msdb, scheduled it to run using an agent job using the SQL Server service acount and it takes nearly 3 times as long, I'd expected it to run slow in VS but not as a scheduled job.
Did you try running it using dtexec?
Is SQL Agent running as a different user?
-Jamie
|||
Is SQL Agent running as a different user?
-Jamie
No, I don't know how to but I'll find out and give it a try.
Yes it is.
|||I'm running the package on the server in each scenario, so no extra networktraffic should take place in any case I think. And the same package (non debug) is used all the time. However, I do run the job as a different user. Should this have any effect?
I'd love to run the package as a command line step, but when I try to do that, I can't seem to get it to read the config-file I'm giving in the command line. Instead an error message complains about that the configuration file cannot be found at the original location (the location given in the settings inside the package). Shouldn't this setting be overridden by the one on the command-line?
regards Andreas
Subscribe to:
Posts (Atom)