Trigger the job automatically

  • 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

  • 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

  • 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