General discussion


Unnecessary job - need opinion

By MirrorMirror ·
I have a dev sql server for a data warehouse that uses a well known application to present and report on the data. So that the developers can work with current data, I made a job that sync's all of the dimension tables and select fact tables from production down to dev every day when no-one is using the app. This pumps several GB of data across our network and takes about an hour to run. This way the data in dev is recent and there is no reason to unnecessarily do the daily data load ETL process. The data in the dev environment is one day behind the data in production. When I made the sync job this was discussed and agreed this was sufficient for the developers to work with.

After figuring out recently that the developers were still doing some development on our production app (that means making new reports that hit the production database, no database structure changes), I adamently requested that they immediately move all development to the development server. (I'm such a mean old DBA!) So, they scheduled a cut over date that has already been missed but have scheduled another one. I hope they actually make this date. While discussing how to sync up DTS packages and other jobs, the developers mentioned that the normal daily data load ETL job for the data warehouse is working in development. This means that we don't need the job I made to sync dev to production. No big deal, I thought, have one or the other job run but not both.

The developers want both to run. The reason that they state for this is that if the daily load ETL breaks then the sync job will still be running. I don't think there is any guarantee of this, but that is what they say. Since this is a dev box, I don't REALLY care but I do think that it is silly to have both jobs running. I am kinda funny about wasteful things when it comes to my database servers. Actually, if I had not spent the time making the sync job, I doubt that I would care at all.

So, should I let both jobs continue to run or only allow one job to run?

This conversation is currently closed to new comments.

12 total posts (Page 2 of 2)   Prev   01 | 02
Thread display: Collapse - | Expand +

All Comments

Collapse -


by MirrorMirror In reply to Picking your battles

Thanks for the replys. Because I already know that I am a control freak with regards to the database servers, I am using TR as the voice of reason. I have been guilty of having a knee jerk reaction to something and having that come back to bite me in the a$$. Since I am the only DBA here I do not have someone to bounce ideas and opinions off and get valid feedback. So, I really appreciate you guys and girls taking my question seriously.

While at times it seems like this place is chaos, I realize that I can really make a difference at this business. It is rewarding despite the struggle.

Collapse -

you're not alone

by K6business In reply to Thanks!

DL50, you're not alone with this kind of problems. I got pretty much the same messy environment when I joined my present company last year. And I think your approach to these issues is right as the developers are not our enemies, they are just used to do it the wrong way and your (and my) job is to convince and teach them how to do it right. It's a slow process, but we'll get there. Good luck!

DBA from Toronto,Canada

Back to Software Forum
12 total posts (Page 2 of 2)   Prev   01 | 02

Related Discussions

Related Forums