Derdack

Targeted Alert Notifications – Anywhere Actions

Derdack
  • Use Cases
    • Overview
    • Enterprise IT Alerting
    • IT Managed Services
    • Mobile Alerting in Manufacuring
    • Critical Operations Alerting in Banking & Financial
    • Field Service Dispatching in Energy & Utilities
    • Use Cases in other Industries
  • Products
    • Overview
    • Enterprise Alert®
      • Overview
      • Alert Notifications
      • On-call Duty Scheduling
      • Collaboration
      • Anywhere Remediation
      • Incident Mgmt. App
      • Integrations
      • Technical Support
      • Online Knowledge Base
      • Derdack FAQ
    • SIGNL4® Cloud
    • References & More
  • How to Buy
    • Overview
    • Pricing and Quotes
    • Find a local Partner
    • Azure Marketplace
  • About Derdack
    • About
    • Careers
    • Partner Program
    • Strategic Partners
    • Derdack Podcast
    • Contact Derdack
  • News & Blog
  • Request Demo
    • de de
  • News & Blog

    • Home
    • News & Blog
    • Technical
    • Get Reminders for your On-Call Duty

    Get Reminders for your On-Call Duty

    • January 10, 2017
    • Technical
    Get Reminders for your On-Call Duty

    As an on-call engineer it is convenient to get reminders before your on-call duty starts. You can configure this easily with Enterprise Alert.

    You can configure on-call reminders directly in the app under Settings -> On-Call Reminders. This will send a reminder every time a user’s duty starts.

    If you do not use the app you can also configure on-call reminders via SMS or email with the following SQL script on the database:

    The following stored procedure is available for setting on-call reminders via SMS or email. The stored procedure already exists.

    CREATE PROCEDURE dbo.sp_OnCallCreateDutyReminder
    (
    @ProfileID int,
    @Action int, — 0 = Nothing, 1 = Send Reminder, 2 = Send modified command
    @ReminderTimeBeforeDuty int,
    @MediaType nvarchar(255),
    @Device nvarchar(255),
    @MaxHierarchy int, — 0 = Primary only, 1 = first backup,… -1 = all
    @Options int — 1 = include standins, 2 = include holidays, 4 = include exception days
    )

    You can call the above remote procedure in the following way.

    EXEC dbo.sp_OnCallCreateDutyReminder <User ID>, 1, 300 /* 5 min before duty start*/, <‘E-mail’ or ‘SMS’>, ”, -1, 7

    First you might want to get the User ID from a given username first using the following query:

    SELECT ID FROM MMPROFILES WHERE PROFNAME =’Administrator’;

    With this user ID you can set the on-call reminders as follows.

    Set reminder via email:

    EXEC dbo.sp_OnCallCreateDutyReminder 1, 1, 300 /*5min*/, ‘E-mail’, ”, -1, 7

    Set reminder via SMS:

    EXEC dbo.sp_OnCallCreateDutyReminder 1, 1, 300 /*5min*/, ‘E-mail’, ”, -1, 7

    The user will then get according reminders before his or her duty starts. The on-call reminder information is then available in the tables OnCallDutyReminders and OnCallPlanUserDutyReminders.

    Tagged

    dutyon-callreminder

    Share

    Related Posts

    On-Prem? Cloud? Hybrid? What is my best option?

    May 16, 2022

    Basic Authentication in Exchange Online ends

    May 6, 2022

    Exploring Enterprise Alert User Types

    March 21, 2022

    Enterprise Alert Update 9.3 brings great improvements for the OPC connector

    February 7, 2022

    About

    DERDACK products combine automated alert notification workflows, 24/7 duty scheduling, ad-hoc collaboration and anywhere IT troubleshooting – reducing unexpected IT downtimes at large enterprises and organizations by 60%.

    Most popular

    • Derdack Company Take your ITIL incident management to the next level with Enterprise Alert
    • Mobile alert notifications for HP Service Manager (HPSM)
    • How to forward alerts to Microsoft Teams
    • Oncall Scheduling On-Call Schedule Management with Auto-Rotation
    • checking-mobile Enhancing SCOM alert notifications
    • Announcing Enterprise Alert 2019
    • Even, Alert, Incident, Notification Definition of Event, Alert, Incident and Notification
    • who-is-on-call-sharepoint Add a live “Who is On-Call” Dashboard into Sharepoint and other Tools

    Categories

    • Business (37)
    • Cloud Services (2)
    • Consultancy (1)
    • Customers (17)
    • Energy & Utilities (7)
    • Events (23)
    • Financial & Banking (4)
    • IT Ops (19)
    • Manufacturing (6)
    • News (47)
    • Schools (1)
    • Software (6)
    • Staffing (1)
    • Support (1)
    • Technical (136)
    • Transport & Logistics (4)

    Tags

    alert alert notification alert notifications Anywhere Resolution Anywhere Response customer reference Database derdack Enterprise Alert enterprise alert Enterprise Alert 2016 Enterprise Alert 2019 event Gartner HPE HPE ITSM Incident resolution incident response Industrie 4.0 Integration IT Alerting IT Operations Maintenance microsoft Microsoft Azure Mobile App monitoring OMS on-call on-call schedule Partnership phone PowerShell rapid response release Remote Action REST API SCADA SCOM security SolarWinds NPM System Center update Users voice

    Follow us

    • Twitter
    • Facebook
    • LinkedIn
    • XING
    • YouTube
    • Vimeo
    • Home
    • News & Blog
    • Technical
    • Get Reminders for your On-Call Duty

    CONTACT US:
    Intl: +49 331 29878-0

    US: +1 (202) 470-0885
    UK: +44 (20) 88167095
    CH: +41 (31) 5391990

    CONTACT VIA EMAIL:
    info@derdack.com

    OFFICES:
    US & Europe

    NEWSLETTER:
    Sign up here

    CAREER:
    Latest job offers

    EVENTS

    • No Upcoming Events
    • Who we help
    • Products
    • How to Buy
    • About Derdack
    • News & Blog
    • Free Trial
    • Twitter
    • LinkedIn
    • XING
    • YouTube
    • Vimeo

     © 2022 Derdack – Imprint, Privacy policy

    • Use Cases
      • Overview
      • Enterprise IT Alerting
      • IT Managed Services
      • Mobile Alerting in Manufacuring
      • Critical Operations Alerting in Banking & Financial
      • Field Service Dispatching in Energy & Utilities
      • Use Cases in other Industries
    • Products
      • Overview
      • Enterprise Alert®
        • Overview
        • Alert Notifications
        • On-call Duty Scheduling
        • Collaboration
        • Anywhere Remediation
        • Incident Mgmt. App
        • Integrations
        • Technical Support
        • Online Knowledge Base
        • Derdack FAQ
      • SIGNL4® Cloud
      • References & More
    • How to Buy
      • Overview
      • Pricing and Quotes
      • Find a local Partner
      • Azure Marketplace
    • About Derdack
      • About
      • Careers
      • Partner Program
      • Strategic Partners
      • Derdack Podcast
      • Contact Derdack
    • News & Blog
    • Request Demo
    Manage Cookie Consent
    We use cookies to optimize our website and our service.
    Functional Always active
    The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
    Preferences
    The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
    Statistics
    The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
    Marketing
    The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
    Manage options Manage services Manage vendors Read more about these purposes
    View preferences
    {title} {title} {title}