When scheduling jobs in the Deployment Server console, the job will not run. Sample jobs that are included with Deployment Server run but the user-created jobs do not.
Cause
When the job is created, a command is processed to insert a record into a task table. A trigger in that table fires to create a record in the task table and then the task table has a trigger that is supposed to insert a record into the event_condition table if none is found. This last step is what is not occurring. This can be a result of a SQL setting "Nested Triggers".
Resolution
Ensure that SQL server is configure to allow nested triggers. This setting can be found in SQL Enterprise manager by right clicking on the server node and choosing properties. On the Server Settings tab, there is a checkmark that reads "Allow triggers to be fired which fire other triggers (nested triggers)."
Once nested triggers are allowed, the job(s) in question will need to be re-created and should run when scheduled.
No comments:
Post a Comment