Status of Scheduled Jobs

Hot Topic

Merge Replication / Metadata Cleanup / Help!
Backup/Restore vs Attach/Detach 2000 Database to 2005
Access database with php access
How do i display a checkbox on a report?
number in words
Cluster failing connections with SSL error message
SQLCLR 32-bit Vs 64-bit
format issue
SQLH2: Empty Performance Counters report
Adding DataSet as DataSource to Report Published on Report Server from ClientSide

SQL Server

restoring 2005 backup with 8.0 compatability mode on 2000 - help
Verify SQL Server 2005 installation
cannot create new sql express database
Image field in Trigger
Using NOT LIKE in a CASE statement
SSIS data Convertion ??
Process cannot connect to distributor error !!!
Matrix Report Not Showing All Columns
Default Filegrowth
Mutiple Cols (Varchar) to XML

Status of Scheduled Jobs

Hi Everyone,

I am using RS 2000 and created the data driven schedules. As per the schedule, the files are getting saved in the remote server. I would like to know how to get the list of failed schedules.

Regards

Venkat

9940198217

ramanmahalingam@Hotmail.com




Answer this question

Status of Scheduled Jobs

  • Anand Raman - MSFT

    In a subscription there will multiple items. These items will be email or saving the files into folder. Suppose one of the item fails then can we monitor from the Subscription table.

  • Jeff Irish

    You can query Subscriptions table in ReportServer database for Status field and compare it to that of success or failure.



  • Status of Scheduled Jobs
Answer this question