Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Cancelled jobs

Former Member
0 Kudos

Hi All

I have to create a program which gets the background jobs cancelled for a particular period.If we have any cancelled jobs then send a SMS.I have the funtionality to send an SMS will you please tell me how to get the background jobs cancelled for a particular period.

Thank You.

Regards

Giri

1 ACCEPTED SOLUTION

Former Member
0 Kudos

SELECT jobname

reluname

strtdate

strttime

FROM tbtco

INTO TABLE t_jobs

WHERE status EQ 'A' and

strtdate GT <value> and

strttime GT <value.

reward if answered

1 REPLY 1

Former Member
0 Kudos

SELECT jobname

reluname

strtdate

strttime

FROM tbtco

INTO TABLE t_jobs

WHERE status EQ 'A' and

strtdate GT <value> and

strttime GT <value.

reward if answered