Is it possible to use both memory and sql storage with background queues

I am trying to figure out how to do two queues for my application and failing miserably. I currently have one storage setup with SQL and it runs x number scheduled background jobs.

Now I would like to have each server run scheduled jobs only for that server.

Example: maintenance to clean up temp files. I assume I can use memory storage for that.

In short how would I setup my application to use two storage mechanism and on application startup initialize the scheduled background job and push them into either the memory starage and sql storage