Post reply

Trigger the job automatically

  • December 13, 2019 at 1:07 pm

    #3707614

    Hi Friends,

    I have a table where data is loaded every morning on a scheduled time. This table is the source for my job which is also scheduled through agent. Some times data availability gets delayed. Due to that job has to be triggered manually. Is there a way to automate this ? Like using any sensors / event triggering or would it be good to use AFTER triggers scripts?  I need you advise. Any suggestions would be appreciated.

    Thanks,
    Charmer

  • December 13, 2019 at 1:31 pm

    #3707643

    Yes, you can certainly use a trigger, or you can periodically query the table for the data and invoke the job when it arrives.

    John

  • December 13, 2019 at 2:12 pm

    #3707658

    Okay, thank you.

    Thanks,
    Charmer

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

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