April 14, 2008 at 1:17 pm
Does anyone know how one would create a view of all DTS packages by their schedules (sql server agent job)?
Or alternatively, scheduled jobs by the DTS package they execute? All jobs on our server are DTS packages that have been right-clicked to schedule (so the cmd is dtsrun {package guid}).
Thanks.
April 14, 2008 at 4:04 pm
You can list jobs by joining msdb.dbo.sysjobs and msdb.dbo.sysjobschedules. Something like:
select name, next_run_date
from sysjobschedules s join sysjobs j on s.job_id = j.job_id
order by next_run_date
Since all your jobs run packages, their probably named after the packages so you'll get what you want. If the jobs hadn't been created by scheduling the packages, you wouldn't have such an easy time of it since the DTSRUN command is encrypted.
Greg
April 14, 2008 at 5:21 pm
ill give it a try, thanks a lot.
also, does anyone recommend a good tool for managing/visualizing scheduled jobs? i tried out the free idera job manager, but it crashed after an agonizingly slow performance (3 times i unintalled/re-installed it). I like the idea and the presentation, but the thing seems to be very beta. Also, I looked at Sql Sentry and that is a bit pricey for me (cheap company, funding this myself).
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply