Search for active jobs and error jobs

All jobs not archived in nssproduction (active on working volume)

login to esr database :

select alfabet, klant , jobnr, jobomschrijving from main where completed = 'N';

All active jobs which have assets in error :

SELECT distinct main.klant,main.jobnr FROM main,asset WHERE asset.main_id=main.main_id AND main.completed='N' AND asset.analyzed='N' AND asset.promoted='Y' ORDER BY main.klant, main.jobnr;