How to trigger a business rule when date becomes current date ?

[Navya]

Hi

I am new to Servicenow, Can you please help me on this

How to trigger a business rule when date becomes current date ?

Thanks,

Navya

[Nitesh Balusu]

Hello Navya,

This is not possible, Business rules only trigger if there is a database update.

What exactly is your purpose? May be i can give you an alternate solution.

[Navya]

Thanks for the response.

I have created three tables

Equipment request - request form for equp

Equipment Task - create task for help desk 

equipment pick up - Equp pick up

on request form user specifies the return date of the equp. When equp return date becomes current date.. Equip pick up task should generate a task to help desk..

So i am trying to trigger a business rule when return date is today. I hope you got it.

Thanks,

Navya

[Nitesh Balusu]

So, in order to achieve what you're trying to do the best method to do is actually create a workflow for the table where the return date field is, workflow waits till the return date and also creates a task which the business rule basically does. This is the best way because workflow triggers exactly at the time of the due date.

If you want do not want to use a workflow, the only option would be to use a scheduled job, again scheduled job has its limitations because it runs AT A CERTAIN TIME but not AT THE TIME OF RETURN DATE. So if you have a scheduled job that runs every one hour, or every day at a certain time it should do what you're asking for but there will be a delay because its going to run at particular intervals.

[Navya]

Sree,

I think schedule will not work, sometimes they use return date as today's. Schedule jobs will run at a specific time. 

I have created a workflow. But i am not seeing the Tasks on the related list.

I am taking Change request as a example.

Thanks,

Navya