Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Posts
    5

    Question Unanswered: How to Execute Stored Proc with Job Scheduler

    hi,

    i want to know How can I execute a Sybase stored Proc with Job Scheduler?

    Please note that it requires input parameters. is it possible?

    thanks

  2. #2
    Join Date
    Mar 2007
    Posts
    72
    hi,
    well..its not directly possible, as you need to make a connection to the database to run a proc. if its windows based run a .bat batch script and call the SP with params from with there. if its unix then a shell script would do the same nicely with an entry in crontab.

    suda

  3. #3
    Join Date
    Dec 2008
    Posts
    4
    u need a cronjob in unix scheduled under crontab directory..and in that job u have to call ur stored proc..........

Posting Permissions

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