Post reply

DTS / job naming strategies

  • January 16, 2004 at 6:40 am

    #84352

    I have 7 production and 6 development SQL Servers that I manage.

    I have a lot of DTS packages and jobs.  It's becoming more and more difficult to find packages and jobs. 

    I was thinking of standardising on a naming convention of this:

    division - export/import/backup/sql script - source - destination - application name - what the job does

    Comments?

     

  • January 19, 2004 at 3:45 pm

    #490743

    Personal preference, but I'd put the application name first. Quite often I'm faced with tracking down problems with XYZ application. If you run the same application in multiple divisions you can follow it with the Division id.

    The main thing is to set a standard, document it, publish it and stick to it.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 2 (of 2 total)

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