I am trying to output to a global variable using a stored procedure using the CM for Databases. I would like to use that variable in a dependent job. The stored proc is completing successfully but does not output to the global variable. My simple stored proc is below and on the Databases tab there a...

This may not be the issue but it is worth a look. My New Day is at 17:00. So if I want jobs to run Mon thru Fri MORNINGS, I have to schedule to order on Sun thru Thur. My weekend jobs are scheduled on Fri and/or Sat.

On PostProc tab:

When: Exectime
Param: >060
To: Level1SupportGroupRecipient
Urgency: Regular
Message: %%JOBNAME has been executing for over an hour.

When: Exectime
Param: >120
To: Level2SupportGroupRecipient
Urgency: Urgent
Message: %%JOBNAME has been executing for over two hours!

I run very little SAS but my command line is below. Maybe this will help. "D:\Program Files\SAS\SASFoundation\9.2\sas.exe" -SYSIN "D:\SAS Folders\SAS Programs\MasterBuildUserTable.sas" -noautoexec -noterminal -nosplash -log %%1 -CONFIG "D:\Program Files\SAS\SASFoundation\9.2\SASV9.CFG" Where %%1 is ...

AFT 6.4 may have this feature. I actually pass the parameter as

Command Line: import_file.bat %%1

and define the xptoFileName varible on the Set tab as

%1 = %%xptoFileName

Using AFT 7.0 you need to set up the transfer as a file watcher and on the Advanced->File Watcher tab set the field Auto-Edit containg detected file name: %%xptoFileName. Then on your batch job following the AFT job, on the command line you pass the paraeter (import_file.bat %%xptoFileName).

I have the job below that looks for a date and if the dates match need to Force jobs. The query output is searched through a POSTCMD batch job. This job runs everyday and only will Fore the job on the one date that matches the output. You may be able to get some ideas to assist. Below is my SQL quer...

Ran it for over a year in our test environment with no issues. Had to disable due licensing issues but otherwise would still be running now.

You could also use a simple "OR between all conditions" on the Conditions tab at the "IN Conditions Relationship:" by having a condition from the "Real" job and the "Dummy" job.

My Control-M is on a windows box. In my Shout Destination Table I have KILLJOB set up as # Destination Type Adr Logical Name Physical Name 13 P S KILLJOB D:\Production\KillJob\KillJob.bat and on the Control-M box I have a batch job (KillJob.bat) located at (D:\Production\KillJob\) at Physical Name a...

Since it is on the File Watcher tab it only works with an AFT with File Watcher. When you select this type of transfer the fields will no longer be grayed out. One issue that I have found using this is that if the first file found matching your file specs is an empty file (0 bytes), it will eventual...

With AFT version 7 and some others below that you can avoid downloading 0 byte files by using the File Watcher and placing a 1 in the Minumum detected file size option on the File Watcher tab. Hope this helps.

If you're looking to verify the source file is the same size as the destination file then you can select this option in the account setup on the Additional Settings tab.

One way is to create a special calendar just for this job and place a Y only for the days you would like it to be ordered and run. The downside is that you will need to maintain it yearly.

Assuming you have AFT 6.4.01.

Select the advanced button for the specific transfer and then select rename for source or destination, whichever you need renamed, and then enter $$AFTFILE$$_FY%%$YEAR. with the period.