SSIS Maintenance Script


Trackbacks

No Trackbacks


Comments
Display comments as (Linear | Threaded)

Ben on :

Thanks for putting this together. It worked great for me.

Ben on :

Mark, I am thinking about writing a sqlservercentral article on my ssisdb problems. I would like to include a link to your blog as I have found it very help. Please let me know if I have permission to include a link.
Thanks,
Ben

Mark Tassin on :

Go for it. I'm a big fan of SSC

pavi on :

how do i add the below code to the

declare @retention_window_length int

select @retention_window_length = cast(property_value as int) from [catalog].[catalog_properties] where property_name = 'RETENTION_WINDOW'

exec [internal].[cleanup_server_retention_window_bottomup] @retention_window_length = @retention_window_length


to the main script..i mean in which location should i add this script..can i run this script seperately in the database?

Mark Tassin on :

What you could do is add

IF @retention_window_length IS NULL SELECT @retention_window_length = cast(property_value as int) from [catalog].[catalog_properties] where property_name='RETENTION_WINDOW'

right after the variable declares in the stored proc.

Also modify the @retention_window_legnth parameter to have = NULL as part of its definition.

Add Comment
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.