New Publisher Won't fire daily
I've created a new publisher, and when I activate it as "every 15 minutes", it will successfully generate a message and put it in the queue. But as soon as I change it to "every 1 day" it fails to do anything. I don't see anything in any error log, and the dts that should be triggered by the message from the publisher never runs. I've waited 48 hours so I'm certain it should have cycled. If I switch back to x minutes, it runs perfectly.
We do already have another publisher that runs 1/day. Is there a limit?