OK, take the code below and modify it to dump everything into a temp table.

Then select jobName from the table where lastRunStat in ('cancelled' or 'failed') then issue a...

ok, I figured it out....join is to sysjobs name to convert(sysname, schedule_id)

Note: it will not list out all subscriptions, but only those that have been scheduled and are active.

I...

My users have the same requirements to

1) Document who has what report subscription

2) Show a list of reports that were scheduled to run...

I have contacted MS Support, will post their responses here.

MS Says

The account that run the setup has domain and local admin permission on that server, it run remotely....

Have you tried installing it in mixed mode, than manually adding the security at a later time using the SA id?

-- Run this procedure to create a nice report for backups

-- Backups are flagged current if within 24 hours old

-- this also tracks deleted databases (marked Legacy) just in...

Have you tried to UNION the results together? This will cause a sort

Also, I find that some of my reports are best ordered by invisable columns that the users...

=Format(Fields!YourFieldName.value, "##,##0.00")

this works better for float numbers, as you can set the decimals ny changing the format string above

Why wait when I can write it my self......Here is a function to convert the seconds to DD:HH:MM:SS

now still wondering if I can toggle or if a new report will...

I was contracting at a company that had a 7TB database of historical transactions.

For this database it was def. worth the effort, as we could partition the...

oh, yes one more thing....once you know the SPID, doa DBCC Inputbuffer(SPID) to get the text of the offending message...

I would say you have some process that is updating every row in your large table.....

do this to identify....this will identify the top disk IO users for the past minute.....change...

You obesrvations correct, they do not have ANY database objects in source control, so opening a job from source is not an option....much along the line of quitting the contract.....lol

From...

The list continues to grow......

Server Security

•Local server access granted to domain user

•Local groups

•Domain Users granted to specific Local groups

•Local disk shares

•FTP access

System Programs

•SQL Server running user-id

•SQL Server Agent running ID

•SSIS...

Anyone know anything at the network level that might cause a connection to "hang" when it is really dropped at the network level?

EP