Jim Horn
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:
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
( 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER