Execute a cron job every Sunday

tarkbyte
HOBBY

10 months ago

Hello, I need to execute a cron job for my app which will modify something in the DB, I didn't find any examples or documentation regarding this.

I am using Next.js, Postgress and DrizzleORM

Any ideas?

0 Replies

tarkbyte
HOBBY

10 months ago

N/A


10 months ago

do you already have a script to do your desired task?


tarkbyte
HOBBY

10 months ago

Do I need to create a new project and deploy it? Can I use my existing Next.js app and use a file as a cron-job?


10 months ago

before we continue, please read this docs page so you can get your terminology correct.


tarkbyte
HOBBY

10 months ago

If I understand correctly, I need to add a new service which will be the cron-job, right?


10 months ago

correct, there you go!


tarkbyte
HOBBY

10 months ago

So I can create a new repo, add something like node-cron and deploy this service?


10 months ago

not quite, you would want to use railways cron scheduler


10 months ago

you can just have a script in your current repo to do your task, and have the cron service run it


tarkbyte
HOBBY

10 months ago

1280330371950444500


tarkbyte
HOBBY

10 months ago

Is this the cron service you are talking about? I don't see where to add my script


tarkbyte
HOBBY

10 months ago

To point to my file which contains the script


10 months ago

correct, and you would be looking for the start command, the start command is how you set the command that starts the script, for example node task.js


tarkbyte
HOBBY

10 months ago

1280336225844072400


tarkbyte
HOBBY

10 months ago

this one?


10 months ago

that's it


10 months ago

of course as you mentioned, you would want to set this up on a duplicate service


tarkbyte
HOBBY

10 months ago

This is what I dont understand, this new service. Is there a template or something I need to use?


10 months ago

nope, right click duplicate, then set your cron schedule, and then set the start command to run whatever script you want ran on a schedule


tarkbyte
HOBBY

10 months ago

Alright, going to test this method. Thanks a lot for your help and patience 😆


tarkbyte
HOBBY

10 months ago

Btw, why it must be duplicated?


10 months ago

because you need two services, one service for nextjs, another service to run the cron job


tarkbyte
HOBBY

10 months ago

oh okay


tarkbyte
HOBBY

10 months ago

Makes sense


10 months ago

a service can't do two different things


10 months ago

one service for one thing, hence the need for two


tarkbyte
HOBBY

10 months ago

Okay I think I got it now. Thanks!


10 months ago

do you have a script that does your task?


10 months ago

or have you yet to write that code?


tarkbyte
HOBBY

10 months ago

Need to write that code


tarkbyte
HOBBY

10 months ago

Don't have it now


10 months ago

okay then that's the next thing you need to do before setting up cron on railway


tarkbyte
HOBBY

10 months ago

Yeah yeah


tarkbyte
HOBBY

10 months ago

Lets say I have this script in a file src/cron/script.js

Can I acces this in the start command like so? node src/cron/script.js


10 months ago

correct


tarkbyte
HOBBY

10 months ago

Alright


tarkbyte
HOBBY

10 months ago

Perfect