SQL Server Performance

DTS

Discussion in 'SQL Server DTS-Related Questions' started by lara99, Jun 26, 2008.

  1. lara99 New Member

    Hi experts , I am in need your help again,
    I have a SQL agent job running at random times, but now i have to implement a condition that if it is between 2pm to 10pm then I have to stop the job from running in other words dont let the job to start. is there an easy way to do this
    Thanks,
    lara99, Jun 26, 2008
    #2

  2. techbabu303 New Member

    What kind of job is that you run ?
    Also why random times ?
    -Sat
    techbabu303, Jun 27, 2008
    #3

  3. lara99 New Member

    its an automationm process followed by many different processes, to reduce the contention on the server we plan that the job should not start between those specific times.
    Thanks
    lara99, Jun 27, 2008
    #4

  4. satya Moderator

    Yes you can do it by using SP_START_JOB & SP_STOP_JOB statements using a query based steps in the SQLAgent jobs category.
    satya, Jun 29, 2008
    #5

Share This Page