Post reply

SQL Jobs Scheduler

  • May 10, 2011 at 11:48 am

    #235998

    I am looking for a SQL Jobs scheduler. I know one of them is Tivoli but it is very expensive. Does anyone has a link to Tivoli site? Also, are there any other scheduler less expensive than Tivoli?

    Thanks.

  • May 10, 2011 at 9:25 pm

    #1322721

    Try CA Autosys ... I am not sure about the price.

    Thank You,

    Best Regards,

    SQLBuddy

  • May 10, 2011 at 9:34 pm

    #1322722

    Are you looking for something not covered by SQL Agent?

  • May 11, 2011 at 8:55 am

    #1323095

    I have a situation where if a job takes longer than expected, then the scheduler should be able to detect that and the subsequent jobs should start only after the previous job ends. I don't believe SQL Agent can do that. Am I right?

    Thanks.

  • May 11, 2011 at 8:56 am

    #1323098

    Yes it's called a step.

    Put the next job in the step or use sp_start job in the next step and drop the schedule for the other job.

  • May 11, 2011 at 9:34 am

    #1323148

    SQL Agent can do that if you make things steps, or write some scripting logic in there. The easy way to do this is to have job 1 write a row in a table when it finishes. Job two should check that table before running, and use a loop to wait. You can chain things together this way. There isn't a lot of restart or other logic here, but it's simple.

    sqlSentry makes a multi-server scheduler that can do what you want (Www.sqlsentry.net)

  • May 11, 2011 at 10:15 am

    #1323211

    Thank you very much, I appreciate it.

  • May 11, 2011 at 10:35 pm

    #1323470

    Sp_startjob starts the Job but doesn't wait until the Job completes.

    If you use that as a Job step then, the Job step will always succeed and goes to the next step and kicks off the next Job . But the Job may actually fail and the next job should not be started. By the time you realize, the damage has already been done. That's the issue with the Sp_startjob.

    Instead use this

    http://www.mssqltips.com/tip.asp?tip=2167

    Thank You,

    Best Regards,

    SQLBuddy

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply