Post reply

schedule a stored procedure

  • June 7, 2005 at 1:08 pm

    #102575

     

    hi

    Is there anyway that I can schedule to run a SP everyday at 12:00 AM. Iam working on a timeclock, if any employee forget to clockout, then the SP will force him to clockout automatically. I need to run this SP everyday. Any help will be appreciated

    thanks

  • June 7, 2005 at 1:12 pm

    #563642

    You could create a task that would be run periodically by the sql server agent (open server in EM, thn gestion, sql server agent, tasks).

    Just schedule it to run to whatever interval, and in the step, just specify which proc to run.

    Also another to make this work would be to check if he forgot the punch out the next time he punches in.

  • June 8, 2005 at 2:25 am

    #563746

    You're assuming that he's not still working at midnight then !!

    I have a few SPs that I run each day and schedule these as agent jobs.

     

  • June 8, 2005 at 6:34 am

    #563778

    God I hope he's done by that time (unless it's a 24H shop???).

  • June 8, 2005 at 10:59 am

    #563891

    I,m done a long back

    thanks

  • November 2, 2006 at 11:33 pm

    #669698

    please tell me how can schedule a stored procedure to run periodically?

    I am new in using stored procedure

  • November 3, 2006 at 6:36 am

    #669759

    Sql server enterprise manager, yourserver / gestion / Sql server agent / jobs

    Create a new job.  From there just check around and you'll see how to make everything work.

     

    If you have problems, just start a new thread (more exposure) and we'll get back to you.

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

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