Home Forums SQL Server 2005 Development How to auto refresh the existing job using stored procedure RE: How to auto refresh the existing job using stored procedure

  • February 14, 2014 at 5:56 am

    #1689040

    sram24_mca (2/14/2014)

    Hi,

    We have an stored procedure to create/execute the job automatically, now we are looking for auto refreshing the job if there is any problem[Data changes] while running the running job. Is there any way to auto refresh the job activity using the same stored procedure?

    Regards,

    Ram

    what do you mean by "auto refresh"?

    do you mean refreshing the GUI in SSMS so that it's status gets updated, instead of clicking refresh?

    do you mean restart some procedure because the data has changed?

    i'm at a loss on what you want to accomplish, so you'll need more details to get help.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!