Execute a cron job every Sunday

tarkbyteHOBBY

8 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

tarkbyteHOBBY

8 months ago

N/A


8 months ago

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


tarkbyteHOBBY

8 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?


8 months ago

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


tarkbyteHOBBY

8 months ago

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


8 months ago

correct, there you go!


tarkbyteHOBBY

8 months ago

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


8 months ago

not quite, you would want to use railways cron scheduler


8 months ago

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


tarkbyteHOBBY

8 months ago

1280330371950444500


tarkbyteHOBBY

8 months ago

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


tarkbyteHOBBY

8 months ago

To point to my file which contains the script


8 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


tarkbyteHOBBY

8 months ago

1280336225844072400


tarkbyteHOBBY

8 months ago

this one?


8 months ago

that's it


8 months ago

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


tarkbyteHOBBY

8 months ago

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


8 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


tarkbyteHOBBY

8 months ago

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


tarkbyteHOBBY

8 months ago

Btw, why it must be duplicated?


8 months ago

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


tarkbyteHOBBY

8 months ago

oh okay


tarkbyteHOBBY

8 months ago

Makes sense


8 months ago

a service can't do two different things


8 months ago

one service for one thing, hence the need for two


tarkbyteHOBBY

8 months ago

Okay I think I got it now. Thanks!


8 months ago

do you have a script that does your task?


8 months ago

or have you yet to write that code?


tarkbyteHOBBY

8 months ago

Need to write that code


tarkbyteHOBBY

8 months ago

Don't have it now


8 months ago

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


tarkbyteHOBBY

8 months ago

Yeah yeah


tarkbyteHOBBY

8 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


8 months ago

correct


tarkbyteHOBBY

8 months ago

Alright


tarkbyteHOBBY

8 months ago

Perfect