Post reply

how to call execution of SQL Job using windows task sheuler

  • June 25, 2018 at 10:17 am

    #352259

    Hi,

    i have task assigned that is how to call sql agent job through task sheduler.
    can i write bat file something like that can you please suggest.

  • June 25, 2018 at 11:22 am

    #1995189

    Diyas - Monday, June 25, 2018 10:17 AM

    Hi,

    i have task assigned that is how to call sql agent job through task sheduler.
    can i write bat file something like that can you please suggest.

    You can write a bat file that executes sqlcmd to call the stored procedure sp_start_job.

    Sue

  • June 25, 2018 at 12:17 pm

    #1995197

    This may be a silly question, but is there a reason you can't schedule the SQL Agent job in SQL Agent?

Viewing 3 posts - 1 through 2 (of 2 total)

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