Register Scheduled CronJob

[Lucas Gutier]

Today we have control of the cronjobs in our environment in an Excel and we want to have this data within ServiceNow. The cronjobs are already inside the CMDB and I thought of using the Schedule field to have this record. The problem is that we have jobs that run from Monday to Friday from 9:00 am to 6:00 pm every 2 minutes and we have nowhere to register this information about the execution every 2 minutes. The idea is to use this information to assemble a Calendar type report with this information. How do you do in these cases? I'm researching but I haven't seen anyone with my peculiarity.

[Amit Gujarathi · Accepted solution]

Hi @Lucas Gutier ,
I trust you are doing great.

To import the cronjob data from Excel to ServiceNow, we can use the ServiceNow Data Import functionality. This will enable us to import the data from the Excel file to the corresponding ServiceNow table.

Once the data is imported, we can leverage the Schedule field in the CMDB to capture the cronjob execution frequency. However, as you mentioned, there is no field available to capture the execution time every 2 minutes from Monday to Friday. In such cases, we can create a custom field on the CMDB table to capture this information.

To create a custom field, we need to navigate to the CMDB table and select the Configure > Form Layout option. From there, we can add a new field and set its type as 'String' or 'Text' depending on the length of the data that needs to be captured.

Once the custom field is added, we can update the Schedule field to capture the execution frequency and the custom field to capture the execution time every 2 minutes from Monday to Friday.

To assemble a calendar type report with this information, we can use the ServiceNow reporting functionality. We can create a new report and select the CMDB table as the source table. From there, we can select the fields we want to display in the report and apply filters based on the execution frequency and time.