Link to home
Start Free TrialLog in
Avatar of Jim Horn
Jim HornFlag for United States of America

asked on

SQL Agent Naming Conventions

Hi All

( This isn't a question as much as it's a member poll, so points will be split across any meaningful answer )

Does anyone use a naming convention for SQL Agent jobs?  Most of my jobs fall under these categories:
  • DBA tasks such as create statistics, reorganizing indexes
  • ETL jobs that archive data to another db or a straight delete of old data no longer needed
  • ETL jobs that load a Data Warehouse / Data Mart
  • One off reports / emails
  • Data validations that I love / emails for any failures

I've inherited a bunch of servers with SQL Agent jobs with poor names, and would like to come up with a standard.

Thanks in advance.
Jim
SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jim Horn

ASKER

Points split across all meaningful answers.  I'll have to write an article on this once I get enough forward progress.  Thanks.  -Jim