Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report needs to run once throughout the semester in infomaker

Status
Not open for further replies.

RV16

IS-IT--Management
Feb 15, 2017
1
0
0
US
If someone has written some reports that runs only once throughout the semester in infomaker, I am thinking about creating a nsc report which has graduates,graduates needs to be cleanup every beginning of the semester. I just want to run once. Can this be accomplished? If so, how?
Do you know other choices?

I am also sharing my update script:

update NSLC_STUDENT_MAST
set NSL_SPECL_STS_DTE=NULL
from student_crs_hist sch join NSLC_STUDENT_MAST nsc
on sch.ID_NUM=nsc.NSL_ID_NUM
join REG_CONFIG on
sch.YR_CDE=REG_CONFIG.CUR_YR_DFLT
and sch.TRM_CDE=REG_CONFIG.CUR_TRM_DFLT
where sch.yr_cDE=@yr and sch.TRM_CDE=@trm and NSL_SPECL_STS='GR'


Thanks in advance
 
You can think of putting it as a schedule from the Tasks on your server. You can set up the time and day for the report to run.

Join PBGeeks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top