Recently I had to do a Stopjob for every package in one site, since I believe in the “lazy administrator philosophy”. I needed to find an easier way to do this task.
Using Query Analyzer and execute the following query, then save the results as a batch file. Don’t forget to put in your site code information.
Select 'stopjob.exe /Destsite:< Your Site Code> /pkgreset /pkgid:' + PackageId from v_Package
The same trick can be used to do a stopjob on one package on every site.