We looked for this feature for years. Queuing jobs on a regular time period. With powerJobs 2015, we introduce such capability. It’s now possible to place a job into the queue every day at 10 o’clock, twice a week, every 10 minutes, or whatever time interval might be more suiting you.
For each job you create, you can also configure a .settings file which contains the definition of the time frame where the job shall be queued, the priority and the message that will show up in the job-queue.
So let’s suppose you have a folder in which your ERP System places text files. Such text files contain document numbers. For such document numbers, the according files shall be copied into a specific folder that is accessible for ERP users.
The job looks quite simple (ScanFolderAndCopyFile.ps1):
$files = Get-ChildItem c:\Temp\erp -File
foreach ($file in $files) {
$content = Get-Content $file.FullName
foreach ($line in $content) {
Get-VaultFile -Properties @{'File Name' = $line } -DownloadPath c:\Temp\ERP\download
}
Remove-Item $file.FullName
}
It gets the files from the specific folder, in my case c:\temp\erp. It reads the content of the files in such folder and expects that the files just contain the desired file name. For each file in such folder, and for each line in each file, the according file will be searched in Vault and copied down to the specified location.
The settings file looks like this (ScanFolderAndCopyFile.settings):
{
"Trigger":
{
"TimeBased": "0 0/1 * 1/1 * ? *",
// This is the name of the Vault you want to trigger the job
"Vault":"Vault",
// And this two parameters are optional and self explaining: "Priority":10,
"Description":"look for files to be copied"
}
}
The key thing in this file is the TimeBased property. The syntax is cron (unix), and for those who are not familiar with, here is a very handy website: http://www.cronmaker.com. Just enter the settings you like, and it generates the syntax which you can then use in this file.
That’s it! You have now a job that gets queued every minute, or depending on how you configured it, scans a folder for data and processes the data. Of course this sample is very simple, but I hope you get the potential behind it. Now it’s up to you to think of all the jobs that you could create with this capability!
Have fun!
coolorange 