Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    32

    Unanswered: How to build job scheduler?

    Could anyone provide the detail procedures? I use ASE 15.
    Many thanks in advance.

  2. #2
    Join Date
    Mar 2007
    Posts
    72
    Hi,
    If you are using UNIX OS then you may use cron to schedule the jobs, this is very reliable and easy to use.

    HTH

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Isn't there a SQL job scheduler in Sybase 15?

    Another option is to just call a stored proc each day (or more frequently) through a cron job as mentioned above. This proc then calls other procs depending on what day it is. It's a good idea to log (in a table) when a proc is starting and when it finished so you can report on whats happening and see whether the time taken for any job is increasing etc.

    Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •