BackupExec itself is not multi-threaded as far as the OS is concerned, so different backup jobs will not use different processors
But if you do other things on the media server, two processors will mean that BackupExec can use one, and everything else the other, so you may see some improvement in performance.