Epicor 9.05 Mass Job Delete

Yahoo Archive
1
That is what I was thinking.  It would be much cleaner using DMT.
Thanks


On Thursday, December 18, 2014 10:10 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-252246660yiv2424751863ygrp-text">
  
  
  <div></div><div dir="ltr"><div class="ygrps-yiv-252246660yiv2424751863gmail_default" style="font-family:verdana, sans-serif;font-size:small;">ERM.... yeah well.... just processing this haaha</div><div class="ygrps-yiv-252246660yiv2424751863gmail_default" style="font-family:verdana, sans-serif;font-size:small;"><br clear="none"></div><div class="ygrps-yiv-252246660yiv2424751863gmail_default" style="font-family:verdana, sans-serif;font-size:small;">I would say yes use DMT, no do not delete from SQL EVER. I know DMT will take a while but it will take care of deleting all the appropriate references it will also let you know if you can&#39;t delete certain jobs because they are used elsewhere (PO Subcontracts, Labor Reflected Against Them etc..)</div><div class="ygrps-yiv-252246660yiv2424751863gmail_default" style="font-family:verdana, sans-serif;font-size:small;"><br clear="none"></div><div class="ygrps-yiv-252246660yiv2424751863gmail_default" style="font-family:verdana, sans-serif;font-size:small;">I would highly encourage you to NEVER , EVER NEVER EVER NEVER EVER NEVER NEVER. Delete from the Epicor tables directly that is not only bad practice but it sets you up to have your support removed and potentially corrupt your application for good.</div><div class="ygrps-yiv-252246660yiv2424751863gmail_default" style="font-family:verdana, sans-serif;font-size:small;"><br clear="none"></div><div class="ygrps-yiv-252246660yiv2424751863gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Thanks!</div></div><div class="ygrps-yiv-252246660yiv2424751863gmail_extra"><br clear="all"><div><div class="ygrps-yiv-252246660yiv2424751863gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#ff6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font face="verdana, sans-serif" size="1"><font color="#ff6600">E:</font> <a rel="nofollow" target="_blank" href="mailto:jose@..." shape="rect">jose@...</a></font><font face="verdana, sans-serif" size="1"><br clear="none"><a rel="nofollow" target="_blank" href="http://www.josecgomez.com/" shape="rect"><font color="#ff6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" style="font-size:small;" target="_blank" href="http://www.linkedin.com/in/josecgomez" shape="rect"><img></a>&nbsp;<a rel="nofollow" style="font-size:small;" target="_blank" href="http://www.facebook.com/josegomez" shape="rect"><img></a>&nbsp;</font><a rel="nofollow" target="_blank" href="http://www.google.com/profiles/jose.gomez" shape="rect"><img></a>&nbsp;<a rel="nofollow" target="_blank" href="http://www.twitter.com/joc85" shape="rect"><img></a>&nbsp;<a rel="nofollow" target="_blank" href="http://www.josecgomez.com/professional-resume/" shape="rect"><img></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" target="_blank" href="http://www.josecgomez.com/feed/" shape="rect"><img></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" size="1" style="font-weight:bold;"><i>Quis custodiet

ipsos custodes?


On Thu, Dec 18, 2014 at 10:01 AM, Kimberley White faepigrl@... [vantage] <vantage@yahoogroups.com> wrote:

  
<div>
  
  
  <div></div><div style="color:rgb(0, 0, 0);font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;background-color:rgb(255, 255, 255);"><div dir="ltr">We are running Epicor 9.05.702A</div><div dir="ltr"><br clear="none">I need to delete a large amount of Jobs.&nbsp; I first tested using SQL and only deleting from JobHead.&nbsp; It still left items behind and on the Time Phase.</div><div dir="ltr">&nbsp;</div><div dir="ltr">I was thinking my approach is wrong and maybe I should use the DMT to delete these Jobs to try to keep it clean.</div><div dir="ltr">&nbsp;</div><div dir="ltr">Any guidance and help appreciated.</div><div dir="ltr">&nbsp;</div><div dir="ltr">Thanks Kim</div></div><div></div>

</div>
 


<div style="color:rgb(255, 255, 255);min-height:0px;"></div>

</div>
 


<div class="ygrps-yiv-252246660yiv2424751863yqt2707573556" id="ygrps-yiv-252246660yiv2424751863yqt33457"><div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863 -- #ygrps-yiv-252246660yiv2424751863ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mkp #ygrps-yiv-252246660yiv2424751863hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mkp #ygrps-yiv-252246660yiv2424751863ads {
margin-bottom:10px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mkp .ygrps-yiv-252246660yiv2424751863ad {
padding:0 0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mkp .ygrps-yiv-252246660yiv2424751863ad p {
margin:0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mkp .ygrps-yiv-252246660yiv2424751863ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-sponsor #ygrps-yiv-252246660yiv2424751863ygrp-lc {
font-family:Arial;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-sponsor #ygrps-yiv-252246660yiv2424751863ygrp-lc #ygrps-yiv-252246660yiv2424751863hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-sponsor #ygrps-yiv-252246660yiv2424751863ygrp-lc .ygrps-yiv-252246660yiv2424751863ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863activity span {
font-weight:700;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863activity span span {
color:#ff7900;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863activity span .ygrps-yiv-252246660yiv2424751863underline {
text-decoration:underline;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863attach div a {
text-decoration:none;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863attach img {
border:none;padding-right:5px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863attach label a {
text-decoration:none;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863bold a {
text-decoration:none;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 dd.ygrps-yiv-252246660yiv2424751863last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 dd.ygrps-yiv-252246660yiv2424751863last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 dd.ygrps-yiv-252246660yiv2424751863last p span.ygrps-yiv-252246660yiv2424751863yshortcuts {
margin-right:0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863attach-table div div a {
text-decoration:none;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863attach-table {
width:400px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863file-title a, #ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863file-title a:active, #ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863file-title a:hover, #ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863file-title a:visited {
text-decoration:none;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863photo-title a, #ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863photo-title a:active, #ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863photo-title a:hover, #ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div.ygrps-yiv-252246660yiv2424751863photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 div#ygrps-yiv-252246660yiv2424751863ygrp-mlmsg #ygrps-yiv-252246660yiv2424751863ygrp-msg p a span.ygrps-yiv-252246660yiv2424751863yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863green {
color:#628c2a;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 o {
font-size:0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863photos div {
float:left;width:72px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863reco-category {
font-size:77%;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863reco-desc {
font-size:77%;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 .ygrps-yiv-252246660yiv2424751863replbq {
margin:4px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mlmsg select, #ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 input, #ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mlmsg pre, #ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 code {
font:115% monospace;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-mlmsg #ygrps-yiv-252246660yiv2424751863logo {
padding-bottom:10px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-msg p#ygrps-yiv-252246660yiv2424751863attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-reco #ygrps-yiv-252246660yiv2424751863reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-sponsor #ygrps-yiv-252246660yiv2424751863ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-sponsor #ygrps-yiv-252246660yiv2424751863ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-sponsor #ygrps-yiv-252246660yiv2424751863ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-text {
font-family:Georgia;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-text tt {
font-size:120%;}

#ygrps-yiv-252246660 #ygrps-yiv-252246660yiv2424751863 #ygrps-yiv-252246660yiv2424751863ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-252246660



2
We are running Epicor 9.05.702A

I need to delete a large amount of Jobs.  I first tested using SQL and only deleting from JobHead.  It still left items behind and on the Time Phase.
 
I was thinking my approach is wrong and maybe I should use the DMT to delete these Jobs to try to keep it clean.
 
Any guidance and help appreciated.
 
Thanks Kim
3
ERM.... yeah well.... just processing this haaha

I would say yes use DMT, no do not delete from SQL EVER. I know DMT will take a while but it will take care of deleting all the appropriate references it will also let you know if you can't delete certain jobs because they are used elsewhere (PO Subcontracts, Labor Reflected Against Them etc..)

I would highly encourage you to NEVER , EVER NEVER EVER NEVER EVER NEVER NEVER. Delete from the Epicor tables directly that is not only bad practice but it sets you up to have your support removed and potentially corrupt your application for good.

Thanks!


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Dec 18, 2014 at 10:01 AM, Kimberley White faepigrl@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div dir="ltr">We are running Epicor 9.05.702A</div><div dir="ltr"><br>I need to delete a large amount of Jobs.  I first tested using SQL and only deleting from JobHead.  It still left items behind and on the Time Phase.</div><div dir="ltr"> </div><div dir="ltr">I was thinking my approach is wrong and maybe I should use the DMT to delete these Jobs to try to keep it clean.</div><div dir="ltr"> </div><div dir="ltr">Any guidance and help appreciated.</div><div dir="ltr"> </div><div dir="ltr">Thanks Kim</div></div><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>