Post reply

SQL Server 2012

  • November 15, 2017 at 1:16 am

    #329522

    Hi,

    We are migrating to new SQL Server 2012 R2 with Always On as previously we had our SQL cluster split in to instances, but just going to have 2 servers now and install all database on 1 server which will replicate to 2nd server. The issue I'm having at the moment is been able to split out the SQL jobs, as in SQL agent - Jobs folder I want to create individual folders to allocate the specific jobs for the database, this will be easier to manage than having hundreds of jobs showing. 

    Is anyone aware of if this is possible?

    Thanks
    Gaz

  • November 15, 2017 at 3:34 am

    #1968139

    ghassan.hassan - Wednesday, November 15, 2017 1:16 AM

    Hi,

    We are migrating to new SQL Server 2012 R2 with Always On as previously we had our SQL cluster split in to instances, but just going to have 2 servers now and install all database on 1 server which will replicate to 2nd server. The issue I'm having at the moment is been able to split out the SQL jobs, as in SQL agent - Jobs folder I want to create individual folders to allocate the specific jobs for the database, this will be easier to manage than having hundreds of jobs showing. 

    Is anyone aware of if this is possible?

    Thanks
    Gaz

    Not possible, the nearest you could do it is to either name all the jobs with a prefix or use categories and filter based on that instead.

    Idera have a free tool for Job Management, not used it personally so cannot say if that will give you more flexibility or not over SSMS.

  • November 15, 2017 at 3:38 am

    #1968141

    Thanks Anthony - this would be a benefit to us all, surely Microsoft can see the benefit -??aaagghh

  • November 15, 2017 at 3:41 am

    #1968142

    ghassan.hassan - Wednesday, November 15, 2017 3:38 AM

    Thanks Anthony - this would be a benefit to us all, surely Microsoft can see the benefit -??aaagghh

    Raise it as a connect item and Microsoft will evaluate it for its potential and if they give it the green light you can expect to see it in a future release.

    I personally prefix my jobs with a keyword and then I filter based on the keyword I am after, eg anything DBA related is prefixed DBA_, anything to do with SAP is SAP_

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply