How to change a Trans-SQL JOB interval programmatically using Java?

[Thiagu Sin]

Hi everyone,

Is there any way to update an existing Trans-SQL Job's interval programmatically?? Kindly help me out.

[Paul Sturrock]

You can just call the relevant system stored procedures I think - from memory it's sp_add_schedule (or something similar) to schedule agent jobs.

[Thiagu Sin]

Paul Sturrock wrote:You can just call the relevant system stored procedures I think - from memory it's sp_add_schedule (or something similar) to schedule agent jobs.

So, once I create a schedule, I can assign the schedule to a particular job and alter the interval dynamically using this procedure sp_update_schedule ???

[Thiagu Sin]

Thiagu Sin wrote:

Paul Sturrock wrote:You can just call the relevant system stored procedures I think - from memory it's sp_add_schedule (or something similar) to schedule agent jobs.

So, once I create a schedule, I can assign the schedule to a particular job and alter the interval dynamically using this procedure sp_update_schedule ???

Hey Paul, it worked.....Thank you very much for the help