Post reply

Job Scheduling

  • October 2, 2008 at 7:07 pm

    #131573

    Hi All,,

    I have a problem in job scheduling in SSIS...SQL agent..

    Actually I am using recurrence property to check every 5 mins and if the FLAG is Y kick off the second job....but the problem is that the recurrence doesn't stop after tht job kicks off..

    Is there any way ..I can stop the recurrence once the job is kicked off..?

    Thanks in Advance...

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • October 2, 2008 at 7:44 pm

    #880259

    I am using a T-SQL to Disable the job ...If I refresh the JOB MONITOR it show the Enabled = NO But still it recurrs the job...Dont know what is wrong

    I disabled the job using following command:

    USE MSDB;

    GO

    UPDATE MSDB.dbo.sysjobs

    SET Enabled = 1

    WHERE [Name] LIKE 'packageJ%';

    GO

    Is there any other property that i need to set to stop it from recirrung ....once it has started..

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

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

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