taskman.py

Go to the documentation of this file.

#!/usr/bin/env python
 
# Copyright (C) 2002-2020 CERN for the benefit of the ATLAS collaboration
 
from __future__ import print_function
 
"""
taskman is a command line utility to run TaskManager functions.
"""
__author__  = 'Juerg Beringer'
__version__ = 'taskman.py atlas/athena'
__usage__   = '''%prog [options] taskdbconn command [args ...]
 
Commands are:
 
init                              Create a new database
checkdb                           Check (and fix) sqlite database
checkdup                          Check task database for duplicate entries
debug                             Interactive debugging (EXPERTS ONLY!)
dump [DSNAME TASKNAME]            Dump all or selected tasks in database
show DSNAME [TASKNAME]            Show list of tasks
update                            Update information of ongoing tasks
update DSNAME TASKNAME            Update information of selected tasks
rebuild [DSNAME TASKNAME]         Rebuild missing or selected database entries from job files
import [DSNAME TASKNAME] DBCONN   Import all or selected tasks from database DBCONN (duplicates not checked)
setstatus DSNAME TASKNAME STATUS  Set status of selected tasks to STATUS
setfield DSNAME TASKNAME FIELDNAME VALUE  Set database field to value (experts only!)
delete DSNAME TASKNAME            Delete entry for selected task(s) (task files are NOT removed)
deleteResults DSNAME TASKNAME     Delete postprocessing results for selected set of tasks
deleteTask DSNAME TASKNAME        Delete task files and corresponding TaskManager entry
                                  for a single task (will prompt for confirmation unless
                                  option --batch is used)
'''
 
import sys, os, stat
import pprint
from InDetBeamSpotExample.TaskManager import *
from InDetBeamSpotExample.Utils import getRunFromName
 
from future import standard_library
standard_library.install_aliases()
import subprocess
 
 
from optparse import OptionParser
parser = OptionParser(usage=__usage__, version=__version__)
#parser.add_option('-x', '--xxx', dest='xx', default='myvalue', help='sample option')
parser.add_option('-b', '--batch', dest='batch', action='store_true', default=False, help='batch mode - never ask for confirmation')
parser.add_option('-v', '--verbose', dest='verbose', action='store_true', default=False, help='enable more verbose output for some commands')
parser.add_option('-n', '--nowildcards', dest='nowildcards', action='store_true', default=False, help='do not add wildcards when looking up dataset and task names')
parser.add_option('-d', '--dbconn', dest='dbconn', default='', help='task manager database connection string (default: check TASKDB, otherwise use sqlite_file:taskdata.db)')
parser.add_option('', '--proddir', dest='proddir', default='.', help='production directory (default: "."')
parser.add_option('-p', '--pretty', dest='pretty', action='store_true', default=None, help='try to nicely format output (default: auto)')
parser.add_option('', '--no-pretty', dest='pretty', action='store_false', help='do not attempt to format output')
parser.add_option('', '--runtaskname', dest='runtaskname', default='CB_BEAMSPOT', help='task name')
(options,args) = parser.parse_args()
 
if len(args) < 1:
    parser.error('wrong number of command line arguments')
cmd = args[0]
cmdargs = args[1:]
 
proddir = options.proddir
if not os.path.exists(proddir):
    sys.exit('ERROR: Job directory %s does not exist or is unreadable' % proddir)
 
def getTaskManager(dbconn=None):
    ''' Open task manager '''
    dbconn = dbconn or options.dbconn
    try:
        return TaskManager(dbconn)
    except:
        print ('ERROR: Unable to access task manager database %s' % dbconn)
        sys.exit(1)
 
#
# Initialize a new task database
#
if cmd == 'init':
    if cmdargs: parser.error('Command init does not take arguments')
    try:
        dbtype, dbname = TaskManager.parseConnectionInfo(options.dbconn)
    except ValueError as e:
        sys.exit('ERROR: {}'.format(e))
    print ('Will initialise schema for database: {}:{}'.format(dbtype, dbname))
 
    print()
    print ('Checking for existing database ...')
    try:
        with TaskManager(options.dbconn): pass
    except ValueError as e:
        print ('Test connection failed: {}'.format(e))
    else:
        print ('Test connection succeeded: the database already exists!')
 
    if not options.batch:
        a = raw_input('\nRECREATING TASK DATABASE SCHEMA - ANY EXISTING DATA WILL BE ERASED!\n\nARE YOU REALLY ABSOLUTELY SURE [n] ? ')
        if a != 'y': sys.exit('ERROR: Rebuilding aborted by user')
        print()
    with TaskManager(options.dbconn, createDatabase=True): pass
    sys.exit(0)
 
 
#
# Check integrity of sqlite database and vacuum, if necessary
#
if cmd == 'checkdb':
    if cmdargs: parser.error('Command checkdb does not take arguments')
    try:
        dbtype, dbfile = TaskManager.parseConnectionInfo(options.dbconn)
    except ValueError:
        sys.exit("ERROR: Illegal or empty/default database connection string - must provide explicity SQLite file reference")
    if dbtype != 'sqlite_file':
        sys.exit('ERROR: checkdb is only supported for SQLite databases')
    if not os.path.exists(dbfile):
        sys.exit('ERROR: SQLite file %s does not exist' % dbfile)
 
    (status, output) = subprocess.getstatusoutput("sqlite3 %s 'pragma integrity_check;'" % dbfile)
    if status != 0:
        sys.exit('ERROR: Error executing sqlite3 command')
    if output != 'ok':
        print ('ERROR: SQLite database file has errors:')
        print (output)
        print()
 
        if not options.batch:
            a = raw_input('Do you want to try VACUUM [n] ? ')
            if a != 'y':
                sys.exit('\nERROR: VACUUM not executed - please fix database file manually')
        (status, output) = subprocess.getstatusoutput("sqlite3 %s 'vacuum;'" % dbfile)
        print (output)
        if status != 0:
            sys.exit('ERROR: VACUUM failed')
 
        (status, output) = subprocess.getstatusoutput("sqlite3 %s 'pragma integrity_check;'" % dbfile)
        if status != 0 or output != 'ok':
            print (output)
            sys.exit('ERROR: Integrity check still failed - please check')
        print ('INFO: SQLite file now passes integrity test (content may still have errors)')
        sys.exit(2)
 
    print ('INFO: SQLite file {} ok'.format(dbfile))
    sys.exit(0)
 
 
#
# Check database for duplicate entries and remove duplicates, if necessary
#
if cmd == 'checkdup':
    if cmdargs: parser.error('Command checkdup does not take arguments')
    #q = ['select dsname,taskname,count(*) from tasks group by dsname,taskname']
    nDuplicates = 0
    with getTaskManager() as taskman:
        for t in taskman.taskIter('dsname,taskname,count(*)', ['group by dsname,taskname']):
            if t[2] > 1:
                nDuplicates += 1
                print ('Duplicate task:  {} / {}'.format(t[0], t[1]))
                for d in taskman.taskIterDict(qual=[
                    'where DSNAME =', DbParam(t[0]),
                    'and TASKNAME =', DbParam(t[1]),
                    'order by taskid']):
                    print ('   TASKID =', d['TASKID'])
    print (nDuplicates, 'duplicates found')
    sys.exit(0)
 
 
#
# Dump contents of task database
#
if cmd == 'dump':
    if not cmdargs:
        with getTaskManager() as taskman:
            print (taskman.getNTasks(),'task(s) found:\n')
            if options.pretty:
                for t in taskman.taskIterDict():
                    print ('\n\nTask {}  /  {}:\n'.format(
                            t['DSNAME'],
                            t['TASKNAME']))
                    print (pprint.pformat(t))
            else:
                for t in taskman.taskIter():
                    print (t)
        sys.exit(0)
 
    elif len(cmdargs) == 2:
        dsname = cmdargs[0]
        taskname = cmdargs[1]
 
        with getTaskManager() as taskman:
            try:
                taskList = getFullTaskNames(taskman, dsname, taskname,
                        addWildCards=not options.nowildcards)
            except TaskManagerCheckError as e:
                sys.exit(e)
            for t in taskList:
                taskEntry = taskman.getTaskDict(t[0], t[1])
                if options.pretty is None or options.pretty:
                    print ('\n\nTask {}  /  {}:\n'.format(
                            taskEntry['DSNAME'],
                            taskEntry['TASKNAME']))
                    print (pprint.pformat(taskEntry))
                else:
                    print (taskEntry)
        sys.exit(0)
 
    else: parser.error('Command dump takes either 0 or 2 arguments')
 
 
#
# Show list of tasks
#
if cmd=='show' and (len(args)==2 or len(args)==3):
    dsname = args[1]
    taskname = args[2] if len(args)>2 else ''
    try:
        with getTaskManager() as taskman:
            taskList = getFullTaskNames(taskman,dsname,taskname,addWildCards=not options.nowildcards)
        print()
        print ("    %-50s  %s" % ('DATASET NAME','TASK NAME'))
        print ("    %s" % (75*'-'))
        for t in taskList:
            print ("    %-50s  %s" % (t[0],t[1])  )
        print ('\n%i task(s) found\n' % len(taskList))
        sys.exit(0)
    except TaskManagerCheckError as e:
        print (e)
        sys.exit(1)
 
 
#
# Update task database entries based on task files on disk
#
if cmd=='update' and len(args)==1:
    if cmdargs: parser.error('Command update does not take any arguments')
 
    with getTaskManager() as taskman:
        for t in taskman.taskIterDict('DSNAME,TASKNAME', [
            'where STATUS < {:d} and ONDISK < {:d}'.format(
                TaskManager.StatusCodes['POSTPROCESSING'],
                TaskManager.OnDiskCodes['ARCHIVED'])]):
            a = TaskAnalyzer(proddir, t['DSNAME'], t['TASKNAME'])
            if a.analyzeFiles():
                print ('Updating task {}/{}'.format(t['DSNAME'], t['TASKNAME']))
                a.updateStatus(taskman)
            else:
                taskman.setDiskStatus(t['DSNAME'], t['TASKNAME'],
                        TaskManager.OnDiskCodes['DELETED'])
    sys.exit(0)
 
if cmd=='update' and len(args)==3:
    with getTaskManager() as taskman:
        try:
            taskList = getFullTaskNames(taskman,args[1],args[2],confirmWithUser=not options.batch,addWildCards=not options.nowildcards)
        except TaskManagerCheckError as e:
            print (e)
            sys.exit(1)
        for t in taskList:
            a = TaskAnalyzer(proddir,t[0],t[1])
            if a.analyzeFiles():
                print ('Updating task %s/%s' % (t[0],t[0]))
                a.updateStatus(taskman)
            else:
                taskman.setDiskStatus(t[0],t[0],TaskManager.OnDiskCodes['DELETED'])
    sys.exit(0)
 
 
#
# Rebuild task database entries based on task files on disk
#
if cmd == 'rebuild':
    if len(cmdargs) == 2:
        dsname = cmdargs[0]
        taskname = cmdargs[1]
        taskpath = os.path.join(proddir, dsname, taskname)
    elif not cmdargs:
        taskpath = os.path.join(proddir, '*', '*')
    else:
        parser.error('Command rebuild takes 0 or 2 arguments')
 
    print ('Will reconstruct database from directory: {}'.format(taskpath))
    print()
 
    with getTaskManager() as taskman:
        dirs = []
        if not options.batch:
            print ('Rebuilding the following tasks:')
            print()
            print ( '    DB  {:50}  {}'.format('DATASET NAME','TASK NAME'))
            print ('    {}'.format(85 * '-'))
            for p in glob.glob(taskpath):
                if not os.path.isdir(p): continue
                (dsName, taskName) = p.split('/')[-2:]
                nDefined = taskman.getNTasks([
                    'where DSNAME=', DbParam(dsName),
                    'and TASKNAME=', DbParam(taskName)])
                dirs.append((dsName, taskName, nDefined))
 
                if nDefined == 0:
                    print ('        {:50}  {}'.format(dsName, taskName))
                elif options.verbose:
                    print ('    *   {:50}  {}'.format(dsName, taskName))
 
            a = raw_input('\nARE YOU SURE [n] ? ')
            if a != 'y':
                sys.exit('ERROR: Rebuilding aborted by user')
            print()
 
        for (dsName, taskName, nDefined) in dirs:
            if nDefined == 0:
                print ('Adding missing entry for task {}/{}'.format(dsName, taskName))
                configFile = glob.glob(os.path.join(proddir, dsName, taskName, '*', '*.config.py'))
                if configFile:
                    mtime = os.stat(configFile[0])[stat.ST_MTIME]
                    config = {}
                    exec(compile(open(configFile[0]).read()), config)
                    try:
                        template = config['jobConfig']['joboptionpath']
                    except KeyError:
                        template = 'UNKNOWN'
                    try:
                        release = config['jobConfig']['release']
                    except KeyError:
                        release = 'UNKNOWN'
                    try:
                        taskpostprocsteps = config['jobConfig']['taskpostprocsteps']
                    except KeyError:
                        taskpostprocsteps = ''
                    try:
                        comment = config['jobConfig']['comment'] + '   (rebuilt from config file)'
                    except KeyError:
                        comment = 'rebuilt from config file'
                    taskman.addTask(dsName, taskName, template, release, 0, taskpostprocsteps,
                            createdTime=mtime,
                            createdUser='UNKNOWN',
                            createdHost='UNKNOWN',
                            comment=comment)
                else:
                    print ('WARNING: no config file found, unable to determine task creation time and configuration details')
                    # Should we still add such a task - most likely this is a directory of files, e.g. some AOD or ESD files
                    taskman.addTask(dsName, taskName, 'UNKNOWN', 'UNKNOWN', 0,
                            comment='rebuilt, no config file found')
                a = TaskAnalyzer(proddir, dsName, taskName)
                a.analyzeFiles()
                a.updateStatus(taskman)
            elif nDefined == 1:
                print ('Entry exists already for task {}/{} - SKIPPED'.format(dsName, taskName))
            elif nDefined > 1:
                print ('ERROR: {:d} conflicting task entries for task {}/{} - SKIPPED'.format(nDefined, dsName, taskName))
    sys.exit(0)
 
 
#
# Import tasks from another task database
#
if cmd == 'import':
    if len(cmdargs) == 1:
        fromDbconn = cmdargs[0]
        qual = []
    elif len(cmdargs) == 3:
        dsname = cmdargs[0]
        taskname = cmdargs[1]
        fromDbconn = cmdargs[2]
 
        # Convert a minimal shell glob syntax into an SQL query:
        import string
        wildcards = string.maketrans('*?', '%_')
        qual = []
        if '*' in dsname or '?' in dsname:
            qual.append("where DSNAME like '{}'".format(dsname.translate(wildcards)))
        else:
            qual.extend(['where DSNAME =', DbParam(dsname)])
        if '*' in taskname or '?' in taskname:
            qual.append("and TASKNAME like '{}'".format(taskname.translate(wildcards)))
        else:
            qual.extend(['and TASKNAME =', DbParam(taskname)])
    else:
        parser.error('Command import takes 1 or 3 arguments')
 
    try:
        destDbtype, destDbname = TaskManager.parseConnectionInfo(options.dbconn)
        fromDbtype, fromDbname = TaskManager.parseConnectionInfo(fromDbconn)
    except ValueError as e:
        sys.exit('ERROR: Bad database connection string {}'.format(e))
    print()
    print ('Import from: {}:{}'.format(fromDbtype, fromDbname))
    print ('Import into: {}:{}'.format(destDbtype, destDbname))
    print()
 
    with getTaskManager() as taskman:
        with getTaskManager(fromDbconn) as fromman:
            nImported = 0
            qual.append('order by RUNNR desc')
            for t in fromman.taskIterDict(qual=qual):
                print ('Importing ', t['DSNAME'], '/' , t['TASKNAME'], '...')
                if not 'RUNNR' in t.keys():
                    # Fill run number from DSNAME
                    t['RUNNR'] = getRunFromName(t['DSNAME'], None, True)
                if not t.get('RESULTLINKS'):
                    # Rebuild old result files and links
                    links = ''
                    files = t.get('RESULTFILES','')
                    if files==None:
                        files = ''
                    dsname = t['DSNAME']
                    taskname = t['TASKNAME']
                    summaryFiles = glob.glob('%s/%s/*beamspot.gif' % (dsname,taskname))
                    if len(summaryFiles)>0:
                        for r in summaryFiles:
                            f = r.split('/')[-1]
                            pdf = f[:-3]+'pdf'
                            if not f in files.split():
                                files = ' '.join([files,f])
                            if not pdf in files.split():
                                files = ' '.join([files,pdf])
                            links += ' <a href="../files?u=%s/%s/%s">summary</a>' %(dsname,taskname,f)
                            links += ' (<a href="/jobfiles/%s/%s/%s">pdf</a>)' %(dsname,taskname,pdf)
                    monitoringFiles = glob.glob('%s/%s/*beamspotmon.gif' % (dsname,taskname))
                    if len(monitoringFiles)>0:
                        for r in monitoringFiles:
                            f = r.split('/')[-1]
                            pdf = f[:-3]+'pdf'
                            if not f in files.split():
                                files = ' '.join([files,f])
                            if not pdf in files.split():
                                files = ' '.join([files,pdf])
                            links += ' <a href="../files?u=%s/%s/%s">monitoring</a>' %(dsname,taskname,f)
                            links += ' (<a href="/jobfiles/%s/%s/%s">pdf</a>)' %(dsname,taskname,pdf)
                    t['RESULTFILES'] = files
                    t['RESULTLINKS'] = links
 
                fieldNameString = ''
                params = []
                for fieldName in t.keys():
                    newFieldName = fieldName
                    if fieldName == 'TASKID':
                        continue # Skip old primary key
                    elif fieldName == 'COMMENT':
                        newFieldName = 'TASKCOMMENT'
                    if params:
                        fieldNameString += ','
                        params.append(',')
                    fieldNameString += newFieldName
                    params.append(DbParam(t[fieldName]))
                q = [ 'insert into TASKS (%s) values (' % fieldNameString ]
                q.extend(params)
                q.append(')')
                taskman.execute(q, True)
                nImported += 1
    print()
    print ('{:d} tasks imported'.format(nImported))
    sys.exit(0)
 
 
#
# Set task status
#
if cmd == 'setstatus':
    if len(cmdargs) != 3: parser.error('Command setstatus takes 3 arguments')
    dsname = cmdargs[0]
    taskname = cmdargs[1]
    statusName = cmdargs[2].upper()
 
    status = TaskManager.StatusCodes.get(statusName)
    if status:
        print ('Setting task status to {} (code {:d})'.format(statusName,status))
    else:
        sys.exit('ERROR: Illegal status code name {}'.format(statusName))
    print()
 
    with getTaskManager() as taskman:
        try:
            taskList = getFullTaskNames(taskman, dsname, taskname,
                    confirmWithUser=not options.batch,
                    addWildCards=not options.nowildcards)
        except TaskManagerCheckError as e:
            sys.exit(e)
 
        n = 0
        for t in taskList:
            n += taskman.setValue(t[0], t[1], 'STATUS', status)
    print ('%i task status entries updated\n' % (n))
    sys.exit(0)
 
 
#
# Set database field
#
if cmd == 'setfield':
    if len(cmdargs) != 4: parser.error('Command setfield takes 4 arguments')
    dsname = cmdargs[0]
    taskname = cmdargs[1]
    fieldName = cmdargs[2].upper()
    fieldValue = cmdargs[3]
 
    print ('Setting field %s to:   %s' % (fieldName,fieldValue))
    print()
    with getTaskManager() as taskman:
        try:
            [(dsname,task)] = getFullTaskNames(taskman, dsname, taskname,
                    requireSingleTask=True,
                    confirmWithUser=not options.batch,
                    addWildCards=not options.nowildcards)
        except TaskManagerCheckError as e:
            sys.exit(e)
        n = taskman.setValue(dsname,task,fieldName,fieldValue)
    print ('{:d} task status entries updated'.format(n))
    sys.exit(0)
 
 
#
# Delete task entry
#
if cmd=='delete' and len(args)==3:
    with getTaskManager() as taskman:
        try:
            taskList = getFullTaskNames(taskman,args[1],args[2],confirmWithUser=not options.batch,addWildCards=not options.nowildcards)
        except TaskManagerCheckError as e:
            print (e)
            sys.exit(1)
        n = 0
        for t in taskList:
            n += taskman.deleteTask(t[0],t[1])
    print ('\n%i task entries deleted\n' % (n))
    sys.exit(0)
 
# List results for selected sets of tasks
#
if cmd=='listResults' and len(args)==3:
    with getTaskManager() as taskman:
        try:
            taskList = getFullTaskNames(taskman,args[1],args[2],confirmWithUser=not options.batch,addWildCards=not options.nowildcards)
        except TaskManagerCheckError as e:
            print (e)
            sys.exit(1)
        for t in taskList:
            print ('Listing results for task %s/%s ...' % (t[0],t[1]) )
            print (taskman.getTaskValue(t[0],t[1],'RESULTFILES'))
            print (taskman.getTaskValue(t[0],t[1],'RESULTLINKS'))
    sys.exit(0)
 
 
#
# Clear results for selected sets of tasks
# TODO: remove associated files as well (?)
#
if cmd=='deleteResults' and len(args)==3:
    with getTaskManager() as taskman:
        try:
            taskList = getFullTaskNames(taskman,args[1],args[2],confirmWithUser=not options.batch,addWildCards=not options.nowildcards)
        except TaskManagerCheckError as e:
            print (e)
            sys.exit(1)
        for t in taskList:
            print ('Deleting results for task %s/%s ...' % (t[0],t[1]) )
            taskman.setValue(t[0],t[1],'RESULTFILES','')
            taskman.setValue(t[0],t[1],'RESULTLINKS','')
    sys.exit(0)
 
 
#
# Delete task (files and associated TaskManager entry)
#
if cmd=='deleteTask' and len(args)==3:
    with getTaskManager() as taskman:
        try:
            [(dsname,task)] = getFullTaskNames(taskman,args[1],args[2],confirmWithUser=not options.batch,requireSingleTask=True,addWildCards=not options.nowildcards)
        except TaskManagerCheckError as e:
            print (e)
            sys.exit(1)
        dir = '/'.join([proddir,dsname,task])
        print()
        if os.path.exists(dir):
            os.system('du -hs %s' % dir)
        else:
            print ('No task files found (no directory %s)' % dir)
        if not options.batch:
            a = input('\nDeleteing task entry and all files - ARE YOU SURE [n] ? ')
            if a!='y':
                print ("ERROR: Deletion aborted by user.")
                sys.exit(1)
        n = taskman.deleteTask(dsname,task)
    print ('\n%i task entry deleted.' % (n))
    print ('Deleting ',dir,' ...')
    os.system('rm -rf %s' % dir)
    sys.exit(0)
 
if cmd=='deleteTask' and len(args)==2:
    dsname = args[1]
    taskname = ''
    with getTaskManager() as taskman:
        try:
            taskList = getFullTaskNames(taskman,dsname,taskname,addWildCards=not options.nowildcards)
        except TaskManagerCheckError as e:
            print (e)
            sys.exit(1)
        print()
        # print ("    %-50s  %s" % ('DATASET NAME','TASK NAME'))
        # print ("    %s" % (75*'-'))
        # for t in taskList:
        #     print ("    %-50s  %s" % (t[0],t[1])  )
        print ('\n%i task(s) found\n' % len(taskList))
        n = 0
        for t in taskList:
            taskname = t[1]
            print ("    %-50s  %s" % (dsname,taskname)  )
            dir = '/'.join([proddir,dsname,taskname])
            print()
            if os.path.exists(dir):
                os.system('du -hs %s' % dir)
            else:
                print ('No task files found (no directory %s)' % dir)
            if not options.batch:
                a = input('\nDeleteing task entry and all files - ARE YOU SURE [n] ? ')
                if a!='y':
                    print ("ERROR: Deletion aborted by user.")
                    sys.exit(1)
            n += taskman.deleteTask(dsname,taskname)
            print ('Deleting ',dir,' ...')
            os.system('rm -rf %s' % dir)
        print ('\n%i tasks deleted.' % (n))
    sys.exit(0)
 
if cmd=='notifyFailed' and len(args)<3:
    if len(args)==2:
        earliestUpdateTime = time.time()-float(args[1])
    else:
        earliestUpdateTime = 0
 
    taskList = []
    with getTaskManager() as taskman:
        for t in taskman.taskIterDict('*',["where TASKNAME like '%%%s%%'" % options.runtaskname,
                                           "and UPDATED >= ", DbParam(earliestUpdateTime),
                                           "and (STATUS = %i or STATUS = %i)" %(TaskManager.StatusCodes['FAILED'], TaskManager.StatusCodes['POSTPROCFAILED']),
                                           "order by RUNNR desc"]):
 
            # Change status to string version
            t['STATUS'] = [k for k, v in TaskManager.StatusCodes.items() if v == t['STATUS']][0]
            taskList.append(t)
 
    if taskList:
 
        dsWidth     = len(max([t['DSNAME'] for t in taskList],key=len))
        taskWidth   = len(max([t['TASKNAME'] for t in taskList],key=len))
        statusWidth = len(max([t['STATUS'] for t in taskList],key=len))
 
        bodyFormat  = '%%(DSNAME)%ss %%(TASKNAME)%ss %%(STATUS)%ss' %(dsWidth, taskWidth, statusWidth)
 
        mailBody = 'The following %s tasks have reported failures' % len(taskList)
        if len(args)==2:
            hours = round(float(args[1])/3600.)
            mailBody += ' in the last %s hours' % hours
        mailBody += ':\n\n'
        mailBody += '\n'.join([bodyFormat % t for t in taskList])
        stat = os.system('source /afs/cern.ch/user/a/atlidbs/cron/mailwrapper; mailwrapper "[atlidbs] %s tasks report failures" "%s"' %(len(taskList), mailBody)) >> 8
 
        if stat:
            print ('\nERROR: Unable to send mail\n')
 
    sys.exit(0)
 
#
# Debugging (for experts only!)
#
# This must be the last command. If we end up here, it's either debugging
# or an illegal command.
#
if cmd=='debug' and len(args)==1:
    taskman = getTaskManager()
    taskman.debug = True
    os.environ['PYTHONINSPECT'] = '1'
    print()
    print ('Entering python shell. taskman is the TaskManager object. Be careful!')
    print()
else:
    print ('ERROR: Illegal command or number of arguments')
    sys.exit(1)