thanks for the direction.

SQL Agent firing - Check

RS Processing Subscriptions - Check

SMTP delivering emails - Check (for many of the subscriptions)

Subscription invalid (I think this may be the issue with...

for the Scheduled jobs, it is a single job with Dynamic SQL for each database or do you have seperate Stored procedures for each production database?

Here is the culprit. Part of a Stored Procedure.

IF @Option = 0

BEGIN

EXEC sp_dboption @DBName, 'trunc. log on chkpt.', 'FALSE'

END

ELSE

BEGIN

EXEC sp_dboption @DBName, 'trunc. log on chkpt.', 'TRUE'

END

The procedure passes in the...

I found that there is a VB 6 windows application that seems to be changing the database to Full. I have reviewed the code but could not find anything...

Thanks. I have found the error in the log and I have found that many of the databases are getting changed to Full model then getting moved back to Simple...