none
Service broker as job scheduler RRS feed

  • Question

  • Hi, I have read that service broker can be used to manage and schedule jobs. but how is this more of an advantage compared to the current sql server job scheduling using the sql server agent. thanks in advance. Would appreciate if somebody can answer immediately
    Wednesday, September 13, 2006 9:20 PM

All replies

  • Is there anything particular you don't like about Agent?

    When internal procedure activation on queues is combined with conversation timers, the result can be a custom build job scheduler. As Adam said, the Broker was not designed as a scheduler, therefore it has no rich API to support job scheduling. There is nothing 'out of the box' that looks like a job scheduler, you'd have to role your own.
    The typical reasons people are looking at broker as a job scheduler are:
    - it eliminates the need for the Agent service to be running
    - it is completely contained inside the database: the entire 'scheduler' fails over with mirroring failover, backup/restore is restoring a consistent 'scheduler' state, the 'schedulre' can be deployed as a simple file copy.
    - jobs can be reliable scheduled remotely using broker conversations
    - the Agent is not available in Express editions while Broker is

    So, unless you have a very specific reason not to, use the SQL Agent.

    HTH,
    ~ Remus

    Thursday, September 14, 2006 3:59 PM
    Moderator