Execute PowerShell Script with Sitecore Scheduler

-

If you have a requirement like execute PowerShell script in form of a scheduler then Sitecore Scheduler provides an option for the same.

For Example, you want to delete some Sitecore Items after a specific date or remove the ideal user at some specific time. For that, you have written a PowerShell script instead of C# code and you want to schedule the PowerShell Script with a Scheduler. Then Sitecore Scheduler provides you a good option to execute PowerShell Script.

If you want to know How to Install the PowerShell module with your Sitecore instance and the ideas about the PowerShell command and Scripts then, please refer series of blog posts written on: PowerShell with Sitecore.

Here I am giving you an example to create a Sitecore Item using PowerShell Script and Schedule that Script by Sitecore Scheduler. You can update your PowerShell script as per your requirement.

Step 1: Go to the PowerShell ISE, you can open it by Sitecore Launchpad or Sitecore -> Development Tools -> Sitecore ISE. It opens an Integrated Scripting Environment for you. Write your PowerShell scripts and check if it is working fine or not. To know about PowerShell ISE, see the blog Post:  PowerShell with Sitecore and Installation.

Execute_Pse_with_Sc_Scheduler_1

Step 2: Save the script. I have named, Create Course Items. You can locate it in the content tree under System -> Module -> PowerShell path. My Script path is: /sitecore/system/Modules/PowerShell/Script Library/Create Course Items

Execute_Pse_with_Sc_Scheduler_2

Step 3: Go to the Scheduler path by /sitecore/system/Tasks/Schedules. Right Click on Schedules and select the Schedule option from Insert Menu. You can select PowerShell Scripted Task Scheduler as well but here I am selecting the Schedule option to make it simpler. I have named it SpeScheduler.

Execute_Pse_with_Sc_Scheduler_3

Step 4: Select the PowerShell Script Command from the Dropdown icon in the Command input box. Enter your earlier saved PowerShell Script path into the Items input box. Enter a specific time interval in the Schedule input box. Now your scheduler is ready to schedule. For more details about How to specify the time in the Schedule input box, see the blog post: Create and Configure Scheduler in Sitecore

Execute_Pse_with_Sc_Scheduler_4

Step 5: Execute the scheduler and check your desired output. In my script, it will create a new item under defined parent path in script.

Execute_Pse_with_Sc_Scheduler_5

Happy Sitecoreing ðŸ˜Š

Comments

Post a Comment

Popular posts from this blog

Sitecore Installation Error: Failed to Start Service 'Sitecore Marketing Automation Engine'

-
Image
 Error: [------- XConnectXP0_StartServices [2] : ManageService -----------------------] [XConnectXP0_StartServices [2]]:[Updating] sc903xconnect.dev.local-MarketingAutomationService Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing ...
Read more

Import CSV Data in Sitecore Using PowerShell: Part-3

-
Image
In my previous blog , we had discussed Sitecore PowerShell Command and Scripts. In this blog, I am discussing with you about How to Import CSV Data in Sitecore using PowerShell Scripts? To do the same you need to read the CSV file rows and create Sitecore Items into the Content Tree for each row then assign the column values of the row into the respective Item Field. There are two options: Write your own customized PowerShell Script and Import CSV Data. Use the inbuilt Data Importer tool that comes with Sitecore PowerShell Extension .  Option 1: Perform the Below steps to Import the CSV Data into Sitecore: First, you will need a CSV file. If you have Excel Sheet, then go to the File Menu and click on Save As option and change the format and save it into CSV format. Suppose you have a CSV file with the number of rows and each row has several columns with predefined values. Here I am taking the below CSV file for an...
Read more

Sitecore : The database principal owns a schema in the database, and cannot be dropped message

-
Image
While upgradation to Sitecore 10.2, I was to restore the database on the Managed Cloud Service Azure SQL Server. I have connected the Azure SQL server on my local SSMS and started to import the Database using the option Import Data-tier Application. While importing the database using the above option you need a BACPAC file instead of a .bak file. So I was to create a BACPAC file of the database from my local. Go to the database, right-click and select the Export Data-tier Application option under the Task menu. After clicking on the next, while creating the BACPAC file you may get the below error: Solution: Go to the Users in that Database. Your Database => Security => Users Find the user, right click and delete it. If you are unable to delete the user and encountered a new error as below: It means the user you are going to delete owns a schema in the database and owners. First, you need to search which schemas own...
Read more