Log shipping

  • Hi Team,
    After configuring log-shipping , I deleted LS_Alert Job ..how can we readd job.

  • dastagiri16 - Tuesday, January 8, 2019 11:31 PM

    Hi Team,
    After configuring log-shipping , I deleted LS_Alert Job ..how can we readd job.

    The only thing that job does is run the stored procedure sys.sp_check_log_shipping_monitor_alert - so you can just create a new job with the following command:
    exec sys.sp_check_log_shipping_monitor_alert

    By default it runs every 2 minutes all day.

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

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