Turning off SQL maintenance plans on Websense SQL server.

Posted on 2008-11-14
Last Modified: 2012-05-05
I need to turn off the built in SQL maintenance plan because they keep filling up hard drive space.  I have a 3rd party solution with a SQL agent.  I have attached a screen shot.  
Which of these jobs can I safely disable?
For the record this this is a dedicated SQL server for our Websense box.

Question by:every1isevil2
    LVL 26

    Accepted Solution

    Well, that depends on what the job does.

    You can see what they do in the Management folder > Maintenance Plans and here you will get the maintenance plans with the same name as the jobs in the Jobs folder. Right click on them > Modify and in the design page that opens you will see the steps involved. Right click on them > Edit and check what they do. When you figured out simply go back to the corresponding job in the Jobs folder that you want to disable and right click on it > Disable.
    LVL 41

    Expert Comment

    There realy aren't any "built in" SQL maintenance plans....   somebody/something created those (for a reason)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now